eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_DCF_AKWRAPPER dependencies on AK_REGION_ITEMS

Line 18: p_region_application_id IN ak_region_items.region_application_id%TYPE,

14: --Who When What
15: ------------------------------------------------------------------------
16:
17: PROCEDURE DCF_CREATE_REGION_ITEM (
18: p_region_application_id IN ak_region_items.region_application_id%TYPE,
19: p_region_code IN ak_region_items.region_code%TYPE,
20: p_attribute_code IN ak_region_items.attribute_code%TYPE,
21: p_display_sequence IN ak_region_items.display_sequence%TYPE,
22: p_node_display_flag IN

Line 19: p_region_code IN ak_region_items.region_code%TYPE,

15: ------------------------------------------------------------------------
16:
17: PROCEDURE DCF_CREATE_REGION_ITEM (
18: p_region_application_id IN ak_region_items.region_application_id%TYPE,
19: p_region_code IN ak_region_items.region_code%TYPE,
20: p_attribute_code IN ak_region_items.attribute_code%TYPE,
21: p_display_sequence IN ak_region_items.display_sequence%TYPE,
22: p_node_display_flag IN
23: ak_region_items.node_display_flag%TYPE DEFAULT 'Y',

Line 20: p_attribute_code IN ak_region_items.attribute_code%TYPE,

16:
17: PROCEDURE DCF_CREATE_REGION_ITEM (
18: p_region_application_id IN ak_region_items.region_application_id%TYPE,
19: p_region_code IN ak_region_items.region_code%TYPE,
20: p_attribute_code IN ak_region_items.attribute_code%TYPE,
21: p_display_sequence IN ak_region_items.display_sequence%TYPE,
22: p_node_display_flag IN
23: ak_region_items.node_display_flag%TYPE DEFAULT 'Y',
24: p_flex_segment_list IN ak_region_items.flex_segment_list%TYPE

Line 21: p_display_sequence IN ak_region_items.display_sequence%TYPE,

17: PROCEDURE DCF_CREATE_REGION_ITEM (
18: p_region_application_id IN ak_region_items.region_application_id%TYPE,
19: p_region_code IN ak_region_items.region_code%TYPE,
20: p_attribute_code IN ak_region_items.attribute_code%TYPE,
21: p_display_sequence IN ak_region_items.display_sequence%TYPE,
22: p_node_display_flag IN
23: ak_region_items.node_display_flag%TYPE DEFAULT 'Y',
24: p_flex_segment_list IN ak_region_items.flex_segment_list%TYPE
25: ) IS

Line 23: ak_region_items.node_display_flag%TYPE DEFAULT 'Y',

19: p_region_code IN ak_region_items.region_code%TYPE,
20: p_attribute_code IN ak_region_items.attribute_code%TYPE,
21: p_display_sequence IN ak_region_items.display_sequence%TYPE,
22: p_node_display_flag IN
23: ak_region_items.node_display_flag%TYPE DEFAULT 'Y',
24: p_flex_segment_list IN ak_region_items.flex_segment_list%TYPE
25: ) IS
26:
27: CURSOR Check_Portaldata_Exist_C IS

Line 24: p_flex_segment_list IN ak_region_items.flex_segment_list%TYPE

20: p_attribute_code IN ak_region_items.attribute_code%TYPE,
21: p_display_sequence IN ak_region_items.display_sequence%TYPE,
22: p_node_display_flag IN
23: ak_region_items.node_display_flag%TYPE DEFAULT 'Y',
24: p_flex_segment_list IN ak_region_items.flex_segment_list%TYPE
25: ) IS
26:
27: CURSOR Check_Portaldata_Exist_C IS
28: SELECT 'Y'

Line 29: FROM Ak_Region_Items

25: ) IS
26:
27: CURSOR Check_Portaldata_Exist_C IS
28: SELECT 'Y'
29: FROM Ak_Region_Items
30: WHERE region_code = p_region_code
31: AND region_application_id = p_region_application_id
32: AND attribute_code = p_attribute_code
33: AND attribute_application_id = 690;

Line 36: l_attribute_application_id ak_region_items.attribute_application_id%TYPE

32: AND attribute_code = p_attribute_code
33: AND attribute_application_id = 690;
34:
35: l_rowid VARCHAR2(200);
36: l_attribute_application_id ak_region_items.attribute_application_id%TYPE
37: := 690;
38: l_node_query_flag ak_region_items.node_query_flag%TYPE := 'N';
39: l_attribute_label_length ak_region_items.attribute_label_length%TYPE :=
40: 0;

Line 38: l_node_query_flag ak_region_items.node_query_flag%TYPE := 'N';

34:
35: l_rowid VARCHAR2(200);
36: l_attribute_application_id ak_region_items.attribute_application_id%TYPE
37: := 690;
38: l_node_query_flag ak_region_items.node_query_flag%TYPE := 'N';
39: l_attribute_label_length ak_region_items.attribute_label_length%TYPE :=
40: 0;
41: l_bold ak_region_items.bold%TYPE := 'N';
42: l_italic ak_region_items.italic%TYPE := 'N';

Line 39: l_attribute_label_length ak_region_items.attribute_label_length%TYPE :=

35: l_rowid VARCHAR2(200);
36: l_attribute_application_id ak_region_items.attribute_application_id%TYPE
37: := 690;
38: l_node_query_flag ak_region_items.node_query_flag%TYPE := 'N';
39: l_attribute_label_length ak_region_items.attribute_label_length%TYPE :=
40: 0;
41: l_bold ak_region_items.bold%TYPE := 'N';
42: l_italic ak_region_items.italic%TYPE := 'N';
43: l_vertical_alignment ak_region_items.vertical_alignment%TYPE :=

Line 41: l_bold ak_region_items.bold%TYPE := 'N';

37: := 690;
38: l_node_query_flag ak_region_items.node_query_flag%TYPE := 'N';
39: l_attribute_label_length ak_region_items.attribute_label_length%TYPE :=
40: 0;
41: l_bold ak_region_items.bold%TYPE := 'N';
42: l_italic ak_region_items.italic%TYPE := 'N';
43: l_vertical_alignment ak_region_items.vertical_alignment%TYPE :=
44: 'TOP';
45: l_horizontal_alignment ak_region_items.horizontal_alignment%TYPE :=

Line 42: l_italic ak_region_items.italic%TYPE := 'N';

38: l_node_query_flag ak_region_items.node_query_flag%TYPE := 'N';
39: l_attribute_label_length ak_region_items.attribute_label_length%TYPE :=
40: 0;
41: l_bold ak_region_items.bold%TYPE := 'N';
42: l_italic ak_region_items.italic%TYPE := 'N';
43: l_vertical_alignment ak_region_items.vertical_alignment%TYPE :=
44: 'TOP';
45: l_horizontal_alignment ak_region_items.horizontal_alignment%TYPE :=
46: 'LEFT';

Line 43: l_vertical_alignment ak_region_items.vertical_alignment%TYPE :=

39: l_attribute_label_length ak_region_items.attribute_label_length%TYPE :=
40: 0;
41: l_bold ak_region_items.bold%TYPE := 'N';
42: l_italic ak_region_items.italic%TYPE := 'N';
43: l_vertical_alignment ak_region_items.vertical_alignment%TYPE :=
44: 'TOP';
45: l_horizontal_alignment ak_region_items.horizontal_alignment%TYPE :=
46: 'LEFT';
47: l_item_style ak_region_items.item_style%TYPE := 'TEXT';

Line 45: l_horizontal_alignment ak_region_items.horizontal_alignment%TYPE :=

41: l_bold ak_region_items.bold%TYPE := 'N';
42: l_italic ak_region_items.italic%TYPE := 'N';
43: l_vertical_alignment ak_region_items.vertical_alignment%TYPE :=
44: 'TOP';
45: l_horizontal_alignment ak_region_items.horizontal_alignment%TYPE :=
46: 'LEFT';
47: l_item_style ak_region_items.item_style%TYPE := 'TEXT';
48: l_object_attribute_flag ak_region_items.object_attribute_flag%TYPE :=
49: 'N';

Line 47: l_item_style ak_region_items.item_style%TYPE := 'TEXT';

43: l_vertical_alignment ak_region_items.vertical_alignment%TYPE :=
44: 'TOP';
45: l_horizontal_alignment ak_region_items.horizontal_alignment%TYPE :=
46: 'LEFT';
47: l_item_style ak_region_items.item_style%TYPE := 'TEXT';
48: l_object_attribute_flag ak_region_items.object_attribute_flag%TYPE :=
49: 'N';
50: l_update_flag ak_region_items.update_flag%TYPE := 'N';
51: l_required_flag ak_region_items.required_flag%TYPE := 'N';

Line 48: l_object_attribute_flag ak_region_items.object_attribute_flag%TYPE :=

44: 'TOP';
45: l_horizontal_alignment ak_region_items.horizontal_alignment%TYPE :=
46: 'LEFT';
47: l_item_style ak_region_items.item_style%TYPE := 'TEXT';
48: l_object_attribute_flag ak_region_items.object_attribute_flag%TYPE :=
49: 'N';
50: l_update_flag ak_region_items.update_flag%TYPE := 'N';
51: l_required_flag ak_region_items.required_flag%TYPE := 'N';
52: l_display_value_length ak_region_items.display_value_length%TYPE :=

Line 50: l_update_flag ak_region_items.update_flag%TYPE := 'N';

46: 'LEFT';
47: l_item_style ak_region_items.item_style%TYPE := 'TEXT';
48: l_object_attribute_flag ak_region_items.object_attribute_flag%TYPE :=
49: 'N';
50: l_update_flag ak_region_items.update_flag%TYPE := 'N';
51: l_required_flag ak_region_items.required_flag%TYPE := 'N';
52: l_display_value_length ak_region_items.display_value_length%TYPE :=
53: 0;
54: l_submit ak_region_items.submit%TYPE := 'N';

Line 51: l_required_flag ak_region_items.required_flag%TYPE := 'N';

47: l_item_style ak_region_items.item_style%TYPE := 'TEXT';
48: l_object_attribute_flag ak_region_items.object_attribute_flag%TYPE :=
49: 'N';
50: l_update_flag ak_region_items.update_flag%TYPE := 'N';
51: l_required_flag ak_region_items.required_flag%TYPE := 'N';
52: l_display_value_length ak_region_items.display_value_length%TYPE :=
53: 0;
54: l_submit ak_region_items.submit%TYPE := 'N';
55: l_encrypt ak_region_items.encrypt%TYPE := 'N';

Line 52: l_display_value_length ak_region_items.display_value_length%TYPE :=

48: l_object_attribute_flag ak_region_items.object_attribute_flag%TYPE :=
49: 'N';
50: l_update_flag ak_region_items.update_flag%TYPE := 'N';
51: l_required_flag ak_region_items.required_flag%TYPE := 'N';
52: l_display_value_length ak_region_items.display_value_length%TYPE :=
53: 0;
54: l_submit ak_region_items.submit%TYPE := 'N';
55: l_encrypt ak_region_items.encrypt%TYPE := 'N';
56: l_admin_customizable ak_region_items.admin_customizable%TYPE :=

Line 54: l_submit ak_region_items.submit%TYPE := 'N';

50: l_update_flag ak_region_items.update_flag%TYPE := 'N';
51: l_required_flag ak_region_items.required_flag%TYPE := 'N';
52: l_display_value_length ak_region_items.display_value_length%TYPE :=
53: 0;
54: l_submit ak_region_items.submit%TYPE := 'N';
55: l_encrypt ak_region_items.encrypt%TYPE := 'N';
56: l_admin_customizable ak_region_items.admin_customizable%TYPE :=
57: 'Y';
58: l_creation_date ak_region_items.creation_date%TYPE := SYSDATE;

Line 55: l_encrypt ak_region_items.encrypt%TYPE := 'N';

51: l_required_flag ak_region_items.required_flag%TYPE := 'N';
52: l_display_value_length ak_region_items.display_value_length%TYPE :=
53: 0;
54: l_submit ak_region_items.submit%TYPE := 'N';
55: l_encrypt ak_region_items.encrypt%TYPE := 'N';
56: l_admin_customizable ak_region_items.admin_customizable%TYPE :=
57: 'Y';
58: l_creation_date ak_region_items.creation_date%TYPE := SYSDATE;
59: l_created_by ak_region_items.created_by%TYPE :=

Line 56: l_admin_customizable ak_region_items.admin_customizable%TYPE :=

52: l_display_value_length ak_region_items.display_value_length%TYPE :=
53: 0;
54: l_submit ak_region_items.submit%TYPE := 'N';
55: l_encrypt ak_region_items.encrypt%TYPE := 'N';
56: l_admin_customizable ak_region_items.admin_customizable%TYPE :=
57: 'Y';
58: l_creation_date ak_region_items.creation_date%TYPE := SYSDATE;
59: l_created_by ak_region_items.created_by%TYPE :=
60: FND_GLOBAL.USER_ID;

Line 58: l_creation_date ak_region_items.creation_date%TYPE := SYSDATE;

54: l_submit ak_region_items.submit%TYPE := 'N';
55: l_encrypt ak_region_items.encrypt%TYPE := 'N';
56: l_admin_customizable ak_region_items.admin_customizable%TYPE :=
57: 'Y';
58: l_creation_date ak_region_items.creation_date%TYPE := SYSDATE;
59: l_created_by ak_region_items.created_by%TYPE :=
60: FND_GLOBAL.USER_ID;
61: l_last_update_date ak_region_items.last_update_date%TYPE :=
62: SYSDATE;

Line 59: l_created_by ak_region_items.created_by%TYPE :=

55: l_encrypt ak_region_items.encrypt%TYPE := 'N';
56: l_admin_customizable ak_region_items.admin_customizable%TYPE :=
57: 'Y';
58: l_creation_date ak_region_items.creation_date%TYPE := SYSDATE;
59: l_created_by ak_region_items.created_by%TYPE :=
60: FND_GLOBAL.USER_ID;
61: l_last_update_date ak_region_items.last_update_date%TYPE :=
62: SYSDATE;
63: l_last_updated_by ak_region_items.last_updated_by%TYPE :=

Line 61: l_last_update_date ak_region_items.last_update_date%TYPE :=

57: 'Y';
58: l_creation_date ak_region_items.creation_date%TYPE := SYSDATE;
59: l_created_by ak_region_items.created_by%TYPE :=
60: FND_GLOBAL.USER_ID;
61: l_last_update_date ak_region_items.last_update_date%TYPE :=
62: SYSDATE;
63: l_last_updated_by ak_region_items.last_updated_by%TYPE :=
64: FND_GLOBAL.USER_ID;
65: l_last_update_login ak_region_items.last_update_login%TYPE :=

Line 63: l_last_updated_by ak_region_items.last_updated_by%TYPE :=

59: l_created_by ak_region_items.created_by%TYPE :=
60: FND_GLOBAL.USER_ID;
61: l_last_update_date ak_region_items.last_update_date%TYPE :=
62: SYSDATE;
63: l_last_updated_by ak_region_items.last_updated_by%TYPE :=
64: FND_GLOBAL.USER_ID;
65: l_last_update_login ak_region_items.last_update_login%TYPE :=
66: FND_GLOBAL.CONC_LOGIN_ID;
67: l_attribute_category ak_region_items.attribute_category%TYPE :=

Line 65: l_last_update_login ak_region_items.last_update_login%TYPE :=

61: l_last_update_date ak_region_items.last_update_date%TYPE :=
62: SYSDATE;
63: l_last_updated_by ak_region_items.last_updated_by%TYPE :=
64: FND_GLOBAL.USER_ID;
65: l_last_update_login ak_region_items.last_update_login%TYPE :=
66: FND_GLOBAL.CONC_LOGIN_ID;
67: l_attribute_category ak_region_items.attribute_category%TYPE :=
68: 'PORTLET_ELEMENT';
69: l_attribute1 ak_region_items.attribute1%TYPE := 'CONSTANT';

Line 67: l_attribute_category ak_region_items.attribute_category%TYPE :=

63: l_last_updated_by ak_region_items.last_updated_by%TYPE :=
64: FND_GLOBAL.USER_ID;
65: l_last_update_login ak_region_items.last_update_login%TYPE :=
66: FND_GLOBAL.CONC_LOGIN_ID;
67: l_attribute_category ak_region_items.attribute_category%TYPE :=
68: 'PORTLET_ELEMENT';
69: l_attribute1 ak_region_items.attribute1%TYPE := 'CONSTANT';
70: l_attribute6 ak_region_items.attribute6%TYPE := 'N';
71:

Line 69: l_attribute1 ak_region_items.attribute1%TYPE := 'CONSTANT';

65: l_last_update_login ak_region_items.last_update_login%TYPE :=
66: FND_GLOBAL.CONC_LOGIN_ID;
67: l_attribute_category ak_region_items.attribute_category%TYPE :=
68: 'PORTLET_ELEMENT';
69: l_attribute1 ak_region_items.attribute1%TYPE := 'CONSTANT';
70: l_attribute6 ak_region_items.attribute6%TYPE := 'N';
71:
72: l_record_exist VARCHAR2(1) := 'N';
73:

Line 70: l_attribute6 ak_region_items.attribute6%TYPE := 'N';

66: FND_GLOBAL.CONC_LOGIN_ID;
67: l_attribute_category ak_region_items.attribute_category%TYPE :=
68: 'PORTLET_ELEMENT';
69: l_attribute1 ak_region_items.attribute1%TYPE := 'CONSTANT';
70: l_attribute6 ak_region_items.attribute6%TYPE := 'N';
71:
72: l_record_exist VARCHAR2(1) := 'N';
73:
74: BEGIN

Line 81: AK_REGION_ITEMS_PKG.INSERT_ROW(

77: FETCH Check_Portaldata_Exist_C INTO l_record_exist;
78: CLOSE Check_Portaldata_Exist_C;
79:
80: IF (l_record_exist = 'N') THEN
81: AK_REGION_ITEMS_PKG.INSERT_ROW(
82: x_rowid => l_rowid,
83: x_region_application_id => p_region_application_id,
84: x_region_code => p_region_code,
85: x_attribute_application_id => l_attribute_application_id,