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.AMS_LIST_QUERY_PVT dependencies on FND_API

Line 56: list_query_id NUMBER := FND_API.G_MISS_NUM,

52:
53: --===================================================================
54: TYPE list_query_rec_type IS RECORD
55: (
56: list_query_id NUMBER := FND_API.G_MISS_NUM,
57: last_update_date DATE := FND_API.G_MISS_DATE,
58: last_updated_by NUMBER := FND_API.G_MISS_NUM,
59: creation_date DATE := FND_API.G_MISS_DATE,
60: created_by NUMBER := FND_API.G_MISS_NUM,

Line 57: last_update_date DATE := FND_API.G_MISS_DATE,

53: --===================================================================
54: TYPE list_query_rec_type IS RECORD
55: (
56: list_query_id NUMBER := FND_API.G_MISS_NUM,
57: last_update_date DATE := FND_API.G_MISS_DATE,
58: last_updated_by NUMBER := FND_API.G_MISS_NUM,
59: creation_date DATE := FND_API.G_MISS_DATE,
60: created_by NUMBER := FND_API.G_MISS_NUM,
61: last_update_login NUMBER := FND_API.G_MISS_NUM,

Line 58: last_updated_by NUMBER := FND_API.G_MISS_NUM,

54: TYPE list_query_rec_type IS RECORD
55: (
56: list_query_id NUMBER := FND_API.G_MISS_NUM,
57: last_update_date DATE := FND_API.G_MISS_DATE,
58: last_updated_by NUMBER := FND_API.G_MISS_NUM,
59: creation_date DATE := FND_API.G_MISS_DATE,
60: created_by NUMBER := FND_API.G_MISS_NUM,
61: last_update_login NUMBER := FND_API.G_MISS_NUM,
62: object_version_number NUMBER := FND_API.G_MISS_NUM,

Line 59: creation_date DATE := FND_API.G_MISS_DATE,

55: (
56: list_query_id NUMBER := FND_API.G_MISS_NUM,
57: last_update_date DATE := FND_API.G_MISS_DATE,
58: last_updated_by NUMBER := FND_API.G_MISS_NUM,
59: creation_date DATE := FND_API.G_MISS_DATE,
60: created_by NUMBER := FND_API.G_MISS_NUM,
61: last_update_login NUMBER := FND_API.G_MISS_NUM,
62: object_version_number NUMBER := FND_API.G_MISS_NUM,
63: name VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 60: created_by NUMBER := FND_API.G_MISS_NUM,

56: list_query_id NUMBER := FND_API.G_MISS_NUM,
57: last_update_date DATE := FND_API.G_MISS_DATE,
58: last_updated_by NUMBER := FND_API.G_MISS_NUM,
59: creation_date DATE := FND_API.G_MISS_DATE,
60: created_by NUMBER := FND_API.G_MISS_NUM,
61: last_update_login NUMBER := FND_API.G_MISS_NUM,
62: object_version_number NUMBER := FND_API.G_MISS_NUM,
63: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
64: type VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 61: last_update_login NUMBER := FND_API.G_MISS_NUM,

57: last_update_date DATE := FND_API.G_MISS_DATE,
58: last_updated_by NUMBER := FND_API.G_MISS_NUM,
59: creation_date DATE := FND_API.G_MISS_DATE,
60: created_by NUMBER := FND_API.G_MISS_NUM,
61: last_update_login NUMBER := FND_API.G_MISS_NUM,
62: object_version_number NUMBER := FND_API.G_MISS_NUM,
63: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
64: type VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 62: object_version_number NUMBER := FND_API.G_MISS_NUM,

58: last_updated_by NUMBER := FND_API.G_MISS_NUM,
59: creation_date DATE := FND_API.G_MISS_DATE,
60: created_by NUMBER := FND_API.G_MISS_NUM,
61: last_update_login NUMBER := FND_API.G_MISS_NUM,
62: object_version_number NUMBER := FND_API.G_MISS_NUM,
63: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
64: type VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
66: primary_key VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 63: name VARCHAR2(240) := FND_API.G_MISS_CHAR,

59: creation_date DATE := FND_API.G_MISS_DATE,
60: created_by NUMBER := FND_API.G_MISS_NUM,
61: last_update_login NUMBER := FND_API.G_MISS_NUM,
62: object_version_number NUMBER := FND_API.G_MISS_NUM,
63: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
64: type VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
66: primary_key VARCHAR2(60) := FND_API.G_MISS_CHAR,
67: source_object_name VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 64: type VARCHAR2(30) := FND_API.G_MISS_CHAR,

60: created_by NUMBER := FND_API.G_MISS_NUM,
61: last_update_login NUMBER := FND_API.G_MISS_NUM,
62: object_version_number NUMBER := FND_API.G_MISS_NUM,
63: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
64: type VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
66: primary_key VARCHAR2(60) := FND_API.G_MISS_CHAR,
67: source_object_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
68: seed_flag varchar2(1) := FND_API.G_MISS_CHAR,

Line 65: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

61: last_update_login NUMBER := FND_API.G_MISS_NUM,
62: object_version_number NUMBER := FND_API.G_MISS_NUM,
63: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
64: type VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
66: primary_key VARCHAR2(60) := FND_API.G_MISS_CHAR,
67: source_object_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
68: seed_flag varchar2(1) := FND_API.G_MISS_CHAR,
69: public_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 66: primary_key VARCHAR2(60) := FND_API.G_MISS_CHAR,

62: object_version_number NUMBER := FND_API.G_MISS_NUM,
63: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
64: type VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
66: primary_key VARCHAR2(60) := FND_API.G_MISS_CHAR,
67: source_object_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
68: seed_flag varchar2(1) := FND_API.G_MISS_CHAR,
69: public_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
70: org_id NUMBER := FND_API.G_MISS_NUM,

Line 67: source_object_name VARCHAR2(60) := FND_API.G_MISS_CHAR,

63: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
64: type VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
66: primary_key VARCHAR2(60) := FND_API.G_MISS_CHAR,
67: source_object_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
68: seed_flag varchar2(1) := FND_API.G_MISS_CHAR,
69: public_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
70: org_id NUMBER := FND_API.G_MISS_NUM,
71: comments VARCHAR2(900) := FND_API.G_MISS_CHAR,

Line 68: seed_flag varchar2(1) := FND_API.G_MISS_CHAR,

64: type VARCHAR2(30) := FND_API.G_MISS_CHAR,
65: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
66: primary_key VARCHAR2(60) := FND_API.G_MISS_CHAR,
67: source_object_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
68: seed_flag varchar2(1) := FND_API.G_MISS_CHAR,
69: public_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
70: org_id NUMBER := FND_API.G_MISS_NUM,
71: comments VARCHAR2(900) := FND_API.G_MISS_CHAR,
72: act_list_query_used_by_id NUMBER := FND_API.G_MISS_NUM,

Line 69: public_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

65: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
66: primary_key VARCHAR2(60) := FND_API.G_MISS_CHAR,
67: source_object_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
68: seed_flag varchar2(1) := FND_API.G_MISS_CHAR,
69: public_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
70: org_id NUMBER := FND_API.G_MISS_NUM,
71: comments VARCHAR2(900) := FND_API.G_MISS_CHAR,
72: act_list_query_used_by_id NUMBER := FND_API.G_MISS_NUM,
73: arc_act_list_query_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 70: org_id NUMBER := FND_API.G_MISS_NUM,

66: primary_key VARCHAR2(60) := FND_API.G_MISS_CHAR,
67: source_object_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
68: seed_flag varchar2(1) := FND_API.G_MISS_CHAR,
69: public_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
70: org_id NUMBER := FND_API.G_MISS_NUM,
71: comments VARCHAR2(900) := FND_API.G_MISS_CHAR,
72: act_list_query_used_by_id NUMBER := FND_API.G_MISS_NUM,
73: arc_act_list_query_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: sql_string VARCHAR2(4000) := FND_API.G_MISS_CHAR,

Line 71: comments VARCHAR2(900) := FND_API.G_MISS_CHAR,

67: source_object_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
68: seed_flag varchar2(1) := FND_API.G_MISS_CHAR,
69: public_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
70: org_id NUMBER := FND_API.G_MISS_NUM,
71: comments VARCHAR2(900) := FND_API.G_MISS_CHAR,
72: act_list_query_used_by_id NUMBER := FND_API.G_MISS_NUM,
73: arc_act_list_query_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: sql_string VARCHAR2(4000) := FND_API.G_MISS_CHAR,
75: parent_list_query_id number := FND_API.G_MISS_NUM,

Line 72: act_list_query_used_by_id NUMBER := FND_API.G_MISS_NUM,

68: seed_flag varchar2(1) := FND_API.G_MISS_CHAR,
69: public_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
70: org_id NUMBER := FND_API.G_MISS_NUM,
71: comments VARCHAR2(900) := FND_API.G_MISS_CHAR,
72: act_list_query_used_by_id NUMBER := FND_API.G_MISS_NUM,
73: arc_act_list_query_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: sql_string VARCHAR2(4000) := FND_API.G_MISS_CHAR,
75: parent_list_query_id number := FND_API.G_MISS_NUM,
76: sequence_order number := FND_API.G_MISS_NUM

Line 73: arc_act_list_query_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,

69: public_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
70: org_id NUMBER := FND_API.G_MISS_NUM,
71: comments VARCHAR2(900) := FND_API.G_MISS_CHAR,
72: act_list_query_used_by_id NUMBER := FND_API.G_MISS_NUM,
73: arc_act_list_query_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: sql_string VARCHAR2(4000) := FND_API.G_MISS_CHAR,
75: parent_list_query_id number := FND_API.G_MISS_NUM,
76: sequence_order number := FND_API.G_MISS_NUM
77: );

Line 74: sql_string VARCHAR2(4000) := FND_API.G_MISS_CHAR,

70: org_id NUMBER := FND_API.G_MISS_NUM,
71: comments VARCHAR2(900) := FND_API.G_MISS_CHAR,
72: act_list_query_used_by_id NUMBER := FND_API.G_MISS_NUM,
73: arc_act_list_query_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: sql_string VARCHAR2(4000) := FND_API.G_MISS_CHAR,
75: parent_list_query_id number := FND_API.G_MISS_NUM,
76: sequence_order number := FND_API.G_MISS_NUM
77: );
78:

Line 75: parent_list_query_id number := FND_API.G_MISS_NUM,

71: comments VARCHAR2(900) := FND_API.G_MISS_CHAR,
72: act_list_query_used_by_id NUMBER := FND_API.G_MISS_NUM,
73: arc_act_list_query_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: sql_string VARCHAR2(4000) := FND_API.G_MISS_CHAR,
75: parent_list_query_id number := FND_API.G_MISS_NUM,
76: sequence_order number := FND_API.G_MISS_NUM
77: );
78:
79: TYPE sql_string_tbl IS TABLE OF VARCHAR2(4000) INDEX BY BINARY_INTEGER;

Line 76: sequence_order number := FND_API.G_MISS_NUM

72: act_list_query_used_by_id NUMBER := FND_API.G_MISS_NUM,
73: arc_act_list_query_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
74: sql_string VARCHAR2(4000) := FND_API.G_MISS_CHAR,
75: parent_list_query_id number := FND_API.G_MISS_NUM,
76: sequence_order number := FND_API.G_MISS_NUM
77: );
78:
79: TYPE sql_string_tbl IS TABLE OF VARCHAR2(4000) INDEX BY BINARY_INTEGER;
80: g_miss_sql_string_tbl sql_string_tbl;

Line 84: list_query_id NUMBER := FND_API.G_MISS_NUM,

80: g_miss_sql_string_tbl sql_string_tbl;
81:
82: TYPE list_query_rec_type_tbl IS RECORD
83: (
84: list_query_id NUMBER := FND_API.G_MISS_NUM,
85: last_update_date DATE := FND_API.G_MISS_DATE,
86: last_updated_by NUMBER := FND_API.G_MISS_NUM,
87: creation_date DATE := FND_API.G_MISS_DATE,
88: created_by NUMBER := FND_API.G_MISS_NUM,

Line 85: last_update_date DATE := FND_API.G_MISS_DATE,

81:
82: TYPE list_query_rec_type_tbl IS RECORD
83: (
84: list_query_id NUMBER := FND_API.G_MISS_NUM,
85: last_update_date DATE := FND_API.G_MISS_DATE,
86: last_updated_by NUMBER := FND_API.G_MISS_NUM,
87: creation_date DATE := FND_API.G_MISS_DATE,
88: created_by NUMBER := FND_API.G_MISS_NUM,
89: last_update_login NUMBER := FND_API.G_MISS_NUM,

Line 86: last_updated_by NUMBER := FND_API.G_MISS_NUM,

82: TYPE list_query_rec_type_tbl IS RECORD
83: (
84: list_query_id NUMBER := FND_API.G_MISS_NUM,
85: last_update_date DATE := FND_API.G_MISS_DATE,
86: last_updated_by NUMBER := FND_API.G_MISS_NUM,
87: creation_date DATE := FND_API.G_MISS_DATE,
88: created_by NUMBER := FND_API.G_MISS_NUM,
89: last_update_login NUMBER := FND_API.G_MISS_NUM,
90: object_version_number NUMBER := FND_API.G_MISS_NUM,

Line 87: creation_date DATE := FND_API.G_MISS_DATE,

83: (
84: list_query_id NUMBER := FND_API.G_MISS_NUM,
85: last_update_date DATE := FND_API.G_MISS_DATE,
86: last_updated_by NUMBER := FND_API.G_MISS_NUM,
87: creation_date DATE := FND_API.G_MISS_DATE,
88: created_by NUMBER := FND_API.G_MISS_NUM,
89: last_update_login NUMBER := FND_API.G_MISS_NUM,
90: object_version_number NUMBER := FND_API.G_MISS_NUM,
91: name VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 88: created_by NUMBER := FND_API.G_MISS_NUM,

84: list_query_id NUMBER := FND_API.G_MISS_NUM,
85: last_update_date DATE := FND_API.G_MISS_DATE,
86: last_updated_by NUMBER := FND_API.G_MISS_NUM,
87: creation_date DATE := FND_API.G_MISS_DATE,
88: created_by NUMBER := FND_API.G_MISS_NUM,
89: last_update_login NUMBER := FND_API.G_MISS_NUM,
90: object_version_number NUMBER := FND_API.G_MISS_NUM,
91: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
92: type VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 89: last_update_login NUMBER := FND_API.G_MISS_NUM,

85: last_update_date DATE := FND_API.G_MISS_DATE,
86: last_updated_by NUMBER := FND_API.G_MISS_NUM,
87: creation_date DATE := FND_API.G_MISS_DATE,
88: created_by NUMBER := FND_API.G_MISS_NUM,
89: last_update_login NUMBER := FND_API.G_MISS_NUM,
90: object_version_number NUMBER := FND_API.G_MISS_NUM,
91: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
92: type VARCHAR2(30) := FND_API.G_MISS_CHAR,
93: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 90: object_version_number NUMBER := FND_API.G_MISS_NUM,

86: last_updated_by NUMBER := FND_API.G_MISS_NUM,
87: creation_date DATE := FND_API.G_MISS_DATE,
88: created_by NUMBER := FND_API.G_MISS_NUM,
89: last_update_login NUMBER := FND_API.G_MISS_NUM,
90: object_version_number NUMBER := FND_API.G_MISS_NUM,
91: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
92: type VARCHAR2(30) := FND_API.G_MISS_CHAR,
93: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
94: primary_key VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 91: name VARCHAR2(240) := FND_API.G_MISS_CHAR,

87: creation_date DATE := FND_API.G_MISS_DATE,
88: created_by NUMBER := FND_API.G_MISS_NUM,
89: last_update_login NUMBER := FND_API.G_MISS_NUM,
90: object_version_number NUMBER := FND_API.G_MISS_NUM,
91: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
92: type VARCHAR2(30) := FND_API.G_MISS_CHAR,
93: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
94: primary_key VARCHAR2(60) := FND_API.G_MISS_CHAR,
95: source_object_name VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 92: type VARCHAR2(30) := FND_API.G_MISS_CHAR,

88: created_by NUMBER := FND_API.G_MISS_NUM,
89: last_update_login NUMBER := FND_API.G_MISS_NUM,
90: object_version_number NUMBER := FND_API.G_MISS_NUM,
91: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
92: type VARCHAR2(30) := FND_API.G_MISS_CHAR,
93: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
94: primary_key VARCHAR2(60) := FND_API.G_MISS_CHAR,
95: source_object_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
96: seed_flag varchar2(1) := FND_API.G_MISS_CHAR,

Line 93: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

89: last_update_login NUMBER := FND_API.G_MISS_NUM,
90: object_version_number NUMBER := FND_API.G_MISS_NUM,
91: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
92: type VARCHAR2(30) := FND_API.G_MISS_CHAR,
93: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
94: primary_key VARCHAR2(60) := FND_API.G_MISS_CHAR,
95: source_object_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
96: seed_flag varchar2(1) := FND_API.G_MISS_CHAR,
97: public_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 94: primary_key VARCHAR2(60) := FND_API.G_MISS_CHAR,

90: object_version_number NUMBER := FND_API.G_MISS_NUM,
91: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
92: type VARCHAR2(30) := FND_API.G_MISS_CHAR,
93: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
94: primary_key VARCHAR2(60) := FND_API.G_MISS_CHAR,
95: source_object_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
96: seed_flag varchar2(1) := FND_API.G_MISS_CHAR,
97: public_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
98: org_id NUMBER := FND_API.G_MISS_NUM,

Line 95: source_object_name VARCHAR2(60) := FND_API.G_MISS_CHAR,

91: name VARCHAR2(240) := FND_API.G_MISS_CHAR,
92: type VARCHAR2(30) := FND_API.G_MISS_CHAR,
93: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
94: primary_key VARCHAR2(60) := FND_API.G_MISS_CHAR,
95: source_object_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
96: seed_flag varchar2(1) := FND_API.G_MISS_CHAR,
97: public_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
98: org_id NUMBER := FND_API.G_MISS_NUM,
99: comments VARCHAR2(900) := FND_API.G_MISS_CHAR,

Line 96: seed_flag varchar2(1) := FND_API.G_MISS_CHAR,

92: type VARCHAR2(30) := FND_API.G_MISS_CHAR,
93: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
94: primary_key VARCHAR2(60) := FND_API.G_MISS_CHAR,
95: source_object_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
96: seed_flag varchar2(1) := FND_API.G_MISS_CHAR,
97: public_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
98: org_id NUMBER := FND_API.G_MISS_NUM,
99: comments VARCHAR2(900) := FND_API.G_MISS_CHAR,
100: act_list_query_used_by_id NUMBER := FND_API.G_MISS_NUM,

Line 97: public_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

93: enabled_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
94: primary_key VARCHAR2(60) := FND_API.G_MISS_CHAR,
95: source_object_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
96: seed_flag varchar2(1) := FND_API.G_MISS_CHAR,
97: public_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
98: org_id NUMBER := FND_API.G_MISS_NUM,
99: comments VARCHAR2(900) := FND_API.G_MISS_CHAR,
100: act_list_query_used_by_id NUMBER := FND_API.G_MISS_NUM,
101: arc_act_list_query_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 98: org_id NUMBER := FND_API.G_MISS_NUM,

94: primary_key VARCHAR2(60) := FND_API.G_MISS_CHAR,
95: source_object_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
96: seed_flag varchar2(1) := FND_API.G_MISS_CHAR,
97: public_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
98: org_id NUMBER := FND_API.G_MISS_NUM,
99: comments VARCHAR2(900) := FND_API.G_MISS_CHAR,
100: act_list_query_used_by_id NUMBER := FND_API.G_MISS_NUM,
101: arc_act_list_query_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: -- t_sql_string_tbl sql_string_tbl := g_miss_sql_string_tbl,

Line 99: comments VARCHAR2(900) := FND_API.G_MISS_CHAR,

95: source_object_name VARCHAR2(60) := FND_API.G_MISS_CHAR,
96: seed_flag varchar2(1) := FND_API.G_MISS_CHAR,
97: public_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
98: org_id NUMBER := FND_API.G_MISS_NUM,
99: comments VARCHAR2(900) := FND_API.G_MISS_CHAR,
100: act_list_query_used_by_id NUMBER := FND_API.G_MISS_NUM,
101: arc_act_list_query_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: -- t_sql_string_tbl sql_string_tbl := g_miss_sql_string_tbl,
103: parent_list_query_id number := FND_API.G_MISS_NUM,

Line 100: act_list_query_used_by_id NUMBER := FND_API.G_MISS_NUM,

96: seed_flag varchar2(1) := FND_API.G_MISS_CHAR,
97: public_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
98: org_id NUMBER := FND_API.G_MISS_NUM,
99: comments VARCHAR2(900) := FND_API.G_MISS_CHAR,
100: act_list_query_used_by_id NUMBER := FND_API.G_MISS_NUM,
101: arc_act_list_query_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: -- t_sql_string_tbl sql_string_tbl := g_miss_sql_string_tbl,
103: parent_list_query_id number := FND_API.G_MISS_NUM,
104: sequence_order number := FND_API.G_MISS_NUM

Line 101: arc_act_list_query_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,

97: public_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
98: org_id NUMBER := FND_API.G_MISS_NUM,
99: comments VARCHAR2(900) := FND_API.G_MISS_CHAR,
100: act_list_query_used_by_id NUMBER := FND_API.G_MISS_NUM,
101: arc_act_list_query_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: -- t_sql_string_tbl sql_string_tbl := g_miss_sql_string_tbl,
103: parent_list_query_id number := FND_API.G_MISS_NUM,
104: sequence_order number := FND_API.G_MISS_NUM
105: );

Line 103: parent_list_query_id number := FND_API.G_MISS_NUM,

99: comments VARCHAR2(900) := FND_API.G_MISS_CHAR,
100: act_list_query_used_by_id NUMBER := FND_API.G_MISS_NUM,
101: arc_act_list_query_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: -- t_sql_string_tbl sql_string_tbl := g_miss_sql_string_tbl,
103: parent_list_query_id number := FND_API.G_MISS_NUM,
104: sequence_order number := FND_API.G_MISS_NUM
105: );
106:
107: -- TYPE list_query_tbl_type IS TABLE OF list_query_rec_type INDEX BY BINARY_INTEGER;

Line 104: sequence_order number := FND_API.G_MISS_NUM

100: act_list_query_used_by_id NUMBER := FND_API.G_MISS_NUM,
101: arc_act_list_query_used_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
102: -- t_sql_string_tbl sql_string_tbl := g_miss_sql_string_tbl,
103: parent_list_query_id number := FND_API.G_MISS_NUM,
104: sequence_order number := FND_API.G_MISS_NUM
105: );
106:
107: -- TYPE list_query_tbl_type IS TABLE OF list_query_rec_type INDEX BY BINARY_INTEGER;
108:

Line 129: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

125: -- Parameters
126: --
127: -- IN
128: -- p_api_version_number IN NUMBER Required
129: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
130: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
131: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
132: -- p_list_query_rec IN list_query_rec_type Required
133: --

Line 130: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

126: --
127: -- IN
128: -- p_api_version_number IN NUMBER Required
129: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
130: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
131: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
132: -- p_list_query_rec IN list_query_rec_type Required
133: --
134: -- OUT

Line 131: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

127: -- IN
128: -- p_api_version_number IN NUMBER Required
129: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
130: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
131: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
132: -- p_list_query_rec IN list_query_rec_type Required
133: --
134: -- OUT
135: -- x_return_status OUT VARCHAR2

Line 148: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

144: --
145:
146: PROCEDURE Create_List_Query(
147: p_api_version_number IN NUMBER,
148: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
149: p_commit IN VARCHAR2 := FND_API.G_FALSE,
150: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
151: x_return_status OUT NOCOPY VARCHAR2,
152: x_msg_count OUT NOCOPY NUMBER,

Line 149: p_commit IN VARCHAR2 := FND_API.G_FALSE,

145:
146: PROCEDURE Create_List_Query(
147: p_api_version_number IN NUMBER,
148: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
149: p_commit IN VARCHAR2 := FND_API.G_FALSE,
150: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
151: x_return_status OUT NOCOPY VARCHAR2,
152: x_msg_count OUT NOCOPY NUMBER,
153: x_msg_data OUT NOCOPY VARCHAR2,

Line 150: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

146: PROCEDURE Create_List_Query(
147: p_api_version_number IN NUMBER,
148: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
149: p_commit IN VARCHAR2 := FND_API.G_FALSE,
150: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
151: x_return_status OUT NOCOPY VARCHAR2,
152: x_msg_count OUT NOCOPY NUMBER,
153: x_msg_data OUT NOCOPY VARCHAR2,
154: p_list_query_rec IN list_query_rec_type := g_miss_list_query_rec,

Line 160: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

156: );
157:
158: PROCEDURE Create_List_Query(
159: p_api_version_number IN NUMBER,
160: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
161: p_commit IN VARCHAR2 := FND_API.G_FALSE,
162: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,

Line 161: p_commit IN VARCHAR2 := FND_API.G_FALSE,

157:
158: PROCEDURE Create_List_Query(
159: p_api_version_number IN NUMBER,
160: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
161: p_commit IN VARCHAR2 := FND_API.G_FALSE,
162: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
165: x_msg_data OUT NOCOPY VARCHAR2,

Line 162: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

158: PROCEDURE Create_List_Query(
159: p_api_version_number IN NUMBER,
160: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
161: p_commit IN VARCHAR2 := FND_API.G_FALSE,
162: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
165: x_msg_data OUT NOCOPY VARCHAR2,
166: p_list_query_rec_tbl IN list_query_rec_type_tbl ,--:= g_miss_list_query_tbl ,

Line 173: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

169: );
170:
171: PROCEDURE Create_List_Query(
172: p_api_version_number IN NUMBER,
173: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
174: p_commit IN VARCHAR2 := FND_API.G_FALSE,
175: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
176: x_return_status OUT NOCOPY VARCHAR2,
177: x_msg_count OUT NOCOPY NUMBER,

Line 174: p_commit IN VARCHAR2 := FND_API.G_FALSE,

170:
171: PROCEDURE Create_List_Query(
172: p_api_version_number IN NUMBER,
173: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
174: p_commit IN VARCHAR2 := FND_API.G_FALSE,
175: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
176: x_return_status OUT NOCOPY VARCHAR2,
177: x_msg_count OUT NOCOPY NUMBER,
178: x_msg_data OUT NOCOPY VARCHAR2,

Line 175: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

171: PROCEDURE Create_List_Query(
172: p_api_version_number IN NUMBER,
173: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
174: p_commit IN VARCHAR2 := FND_API.G_FALSE,
175: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
176: x_return_status OUT NOCOPY VARCHAR2,
177: x_msg_count OUT NOCOPY NUMBER,
178: x_msg_data OUT NOCOPY VARCHAR2,
179: p_list_query_rec_tbl IN list_query_rec_type_tbl ,--:= g_miss_list_query_tbl ,

Line 199: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

195: -- Parameters
196: --
197: -- IN
198: -- p_api_version_number IN NUMBER Required
199: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
200: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
201: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
202: -- p_list_query_rec IN list_query_rec_type Required
203: --

Line 200: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

196: --
197: -- IN
198: -- p_api_version_number IN NUMBER Required
199: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
200: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
201: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
202: -- p_list_query_rec IN list_query_rec_type Required
203: --
204: -- OUT

Line 201: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

197: -- IN
198: -- p_api_version_number IN NUMBER Required
199: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
200: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
201: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
202: -- p_list_query_rec IN list_query_rec_type Required
203: --
204: -- OUT
205: -- x_return_status OUT VARCHAR2

Line 218: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

214: --
215:
216: PROCEDURE Update_List_Query(
217: p_api_version_number IN NUMBER,
218: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
219: p_commit IN VARCHAR2 := FND_API.G_FALSE,
220: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
221: x_return_status OUT NOCOPY VARCHAR2,
222: x_msg_count OUT NOCOPY NUMBER,

Line 219: p_commit IN VARCHAR2 := FND_API.G_FALSE,

215:
216: PROCEDURE Update_List_Query(
217: p_api_version_number IN NUMBER,
218: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
219: p_commit IN VARCHAR2 := FND_API.G_FALSE,
220: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
221: x_return_status OUT NOCOPY VARCHAR2,
222: x_msg_count OUT NOCOPY NUMBER,
223: x_msg_data OUT NOCOPY VARCHAR2,

Line 220: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

216: PROCEDURE Update_List_Query(
217: p_api_version_number IN NUMBER,
218: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
219: p_commit IN VARCHAR2 := FND_API.G_FALSE,
220: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
221: x_return_status OUT NOCOPY VARCHAR2,
222: x_msg_count OUT NOCOPY NUMBER,
223: x_msg_data OUT NOCOPY VARCHAR2,
224: p_list_query_rec IN list_query_rec_type,

Line 230: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

226: );
227:
228: PROCEDURE Update_List_Query(
229: p_api_version_number IN NUMBER,
230: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
231: p_commit IN VARCHAR2 := FND_API.G_FALSE,
232: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
233: x_return_status OUT NOCOPY VARCHAR2,
234: x_msg_count OUT NOCOPY NUMBER,

Line 231: p_commit IN VARCHAR2 := FND_API.G_FALSE,

227:
228: PROCEDURE Update_List_Query(
229: p_api_version_number IN NUMBER,
230: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
231: p_commit IN VARCHAR2 := FND_API.G_FALSE,
232: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
233: x_return_status OUT NOCOPY VARCHAR2,
234: x_msg_count OUT NOCOPY NUMBER,
235: x_msg_data OUT NOCOPY VARCHAR2,

Line 232: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

228: PROCEDURE Update_List_Query(
229: p_api_version_number IN NUMBER,
230: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
231: p_commit IN VARCHAR2 := FND_API.G_FALSE,
232: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
233: x_return_status OUT NOCOPY VARCHAR2,
234: x_msg_count OUT NOCOPY NUMBER,
235: x_msg_data OUT NOCOPY VARCHAR2,
236: p_list_query_rec_tbl IN list_query_rec_type_tbl,

Line 254: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

250: -- Parameters
251: --
252: -- IN
253: -- p_api_version_number IN NUMBER Required
254: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
255: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
256: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
257: -- p_LIST_QUERY_ID IN NUMBER
258: -- p_object_version_number IN NUMBER Optional Default = NULL

Line 255: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

251: --
252: -- IN
253: -- p_api_version_number IN NUMBER Required
254: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
255: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
256: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
257: -- p_LIST_QUERY_ID IN NUMBER
258: -- p_object_version_number IN NUMBER Optional Default = NULL
259: --

Line 256: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

252: -- IN
253: -- p_api_version_number IN NUMBER Required
254: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
255: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
256: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
257: -- p_LIST_QUERY_ID IN NUMBER
258: -- p_object_version_number IN NUMBER Optional Default = NULL
259: --
260: -- OUT

Line 274: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

270: --
271:
272: PROCEDURE Delete_List_Query(
273: p_api_version_number IN NUMBER,
274: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
275: p_commit IN VARCHAR2 := FND_API.G_FALSE,
276: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
277: x_return_status OUT NOCOPY VARCHAR2,
278: x_msg_count OUT NOCOPY NUMBER,

Line 275: p_commit IN VARCHAR2 := FND_API.G_FALSE,

271:
272: PROCEDURE Delete_List_Query(
273: p_api_version_number IN NUMBER,
274: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
275: p_commit IN VARCHAR2 := FND_API.G_FALSE,
276: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
277: x_return_status OUT NOCOPY VARCHAR2,
278: x_msg_count OUT NOCOPY NUMBER,
279: x_msg_data OUT NOCOPY VARCHAR2,

Line 276: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

272: PROCEDURE Delete_List_Query(
273: p_api_version_number IN NUMBER,
274: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
275: p_commit IN VARCHAR2 := FND_API.G_FALSE,
276: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
277: x_return_status OUT NOCOPY VARCHAR2,
278: x_msg_count OUT NOCOPY NUMBER,
279: x_msg_data OUT NOCOPY VARCHAR2,
280: p_list_query_id IN NUMBER,

Line 286: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

282: );
283:
284: PROCEDURE Delete_parent_List_Query(
285: p_api_version_number IN NUMBER,
286: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
287: p_commit IN VARCHAR2 := FND_API.G_FALSE,
288: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
289: x_return_status OUT NOCOPY VARCHAR2,
290: x_msg_count OUT NOCOPY NUMBER,

Line 287: p_commit IN VARCHAR2 := FND_API.G_FALSE,

283:
284: PROCEDURE Delete_parent_List_Query(
285: p_api_version_number IN NUMBER,
286: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
287: p_commit IN VARCHAR2 := FND_API.G_FALSE,
288: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
289: x_return_status OUT NOCOPY VARCHAR2,
290: x_msg_count OUT NOCOPY NUMBER,
291: x_msg_data OUT NOCOPY VARCHAR2,

Line 288: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

284: PROCEDURE Delete_parent_List_Query(
285: p_api_version_number IN NUMBER,
286: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
287: p_commit IN VARCHAR2 := FND_API.G_FALSE,
288: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
289: x_return_status OUT NOCOPY VARCHAR2,
290: x_msg_count OUT NOCOPY NUMBER,
291: x_msg_data OUT NOCOPY VARCHAR2,
292: p_parent_list_query_id IN NUMBER,

Line 309: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

305: -- Parameters
306: --
307: -- IN
308: -- p_api_version_number IN NUMBER Required
309: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
310: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
311: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
312: -- p_list_query_rec IN list_query_rec_type Required
313: --

Line 310: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

306: --
307: -- IN
308: -- p_api_version_number IN NUMBER Required
309: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
310: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
311: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
312: -- p_list_query_rec IN list_query_rec_type Required
313: --
314: -- OUT

Line 311: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

307: -- IN
308: -- p_api_version_number IN NUMBER Required
309: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
310: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
311: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
312: -- p_list_query_rec IN list_query_rec_type Required
313: --
314: -- OUT
315: -- x_return_status OUT VARCHAR2

Line 328: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

324: --
325:
326: PROCEDURE Lock_List_Query(
327: p_api_version_number IN NUMBER,
328: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
329: x_return_status OUT NOCOPY VARCHAR2,
330: x_msg_count OUT NOCOPY NUMBER,
331: x_msg_data OUT NOCOPY VARCHAR2,
332: p_list_query_id IN NUMBER,

Line 350: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

346: -- End of Comments
347:
348: PROCEDURE Validate_list_query(
349: p_api_version_number IN NUMBER,
350: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
351: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
352: p_list_query_rec IN list_query_rec_type,
353: x_return_status OUT NOCOPY VARCHAR2,
354: x_msg_count OUT NOCOPY NUMBER,

Line 351: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

347:
348: PROCEDURE Validate_list_query(
349: p_api_version_number IN NUMBER,
350: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
351: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
352: p_list_query_rec IN list_query_rec_type,
353: x_return_status OUT NOCOPY VARCHAR2,
354: x_msg_count OUT NOCOPY NUMBER,
355: x_msg_data OUT NOCOPY VARCHAR2

Line 388: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

384: -- End of Comments
385:
386: PROCEDURE Validate_list_query_rec(
387: p_api_version_number IN NUMBER,
388: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
389: x_return_status OUT NOCOPY VARCHAR2,
390: x_msg_count OUT NOCOPY NUMBER,
391: x_msg_data OUT NOCOPY VARCHAR2,
392: p_list_query_rec IN list_query_rec_type

Line 418: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

414:
415:
416: PROCEDURE Copy_List_Queries
417: ( p_api_version IN NUMBER,
418: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
419: p_commit IN VARCHAR2 := FND_API.G_FALSE,
420: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
421: p_source_listheader_id IN NUMBER,
422: p_new_listheader_id IN NUMBER,

Line 419: p_commit IN VARCHAR2 := FND_API.G_FALSE,

415:
416: PROCEDURE Copy_List_Queries
417: ( p_api_version IN NUMBER,
418: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
419: p_commit IN VARCHAR2 := FND_API.G_FALSE,
420: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
421: p_source_listheader_id IN NUMBER,
422: p_new_listheader_id IN NUMBER,
423: p_new_listheader_name IN VARCHAR2,

Line 420: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

416: PROCEDURE Copy_List_Queries
417: ( p_api_version IN NUMBER,
418: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
419: p_commit IN VARCHAR2 := FND_API.G_FALSE,
420: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
421: p_source_listheader_id IN NUMBER,
422: p_new_listheader_id IN NUMBER,
423: p_new_listheader_name IN VARCHAR2,
424: