DBA Data[Home] [Help]

APPS.CSI_MASS_EDIT_PUB dependencies on FND_API

Line 18: entry_id NUMBER := fnd_api.g_miss_num

14:
15:
16: TYPE mass_edit_rec IS RECORD
17: (
18: entry_id NUMBER := fnd_api.g_miss_num
19: ,name VARCHAR2(50) := fnd_api.g_miss_char
20: ,txn_line_id NUMBER := fnd_api.g_miss_num
21: ,txn_line_detail_id NUMBER := fnd_api.g_miss_num
22: ,status_code VARCHAR2(30) := fnd_api.g_miss_char

Line 19: ,name VARCHAR2(50) := fnd_api.g_miss_char

15:
16: TYPE mass_edit_rec IS RECORD
17: (
18: entry_id NUMBER := fnd_api.g_miss_num
19: ,name VARCHAR2(50) := fnd_api.g_miss_char
20: ,txn_line_id NUMBER := fnd_api.g_miss_num
21: ,txn_line_detail_id NUMBER := fnd_api.g_miss_num
22: ,status_code VARCHAR2(30) := fnd_api.g_miss_char
23: ,batch_type VARCHAR2(30) := fnd_api.g_miss_char

Line 20: ,txn_line_id NUMBER := fnd_api.g_miss_num

16: TYPE mass_edit_rec IS RECORD
17: (
18: entry_id NUMBER := fnd_api.g_miss_num
19: ,name VARCHAR2(50) := fnd_api.g_miss_char
20: ,txn_line_id NUMBER := fnd_api.g_miss_num
21: ,txn_line_detail_id NUMBER := fnd_api.g_miss_num
22: ,status_code VARCHAR2(30) := fnd_api.g_miss_char
23: ,batch_type VARCHAR2(30) := fnd_api.g_miss_char
24: ,description VARCHAR2(2000):= fnd_api.g_miss_char

Line 21: ,txn_line_detail_id NUMBER := fnd_api.g_miss_num

17: (
18: entry_id NUMBER := fnd_api.g_miss_num
19: ,name VARCHAR2(50) := fnd_api.g_miss_char
20: ,txn_line_id NUMBER := fnd_api.g_miss_num
21: ,txn_line_detail_id NUMBER := fnd_api.g_miss_num
22: ,status_code VARCHAR2(30) := fnd_api.g_miss_char
23: ,batch_type VARCHAR2(30) := fnd_api.g_miss_char
24: ,description VARCHAR2(2000):= fnd_api.g_miss_char
25: ,schedule_date DATE := fnd_api.g_miss_date

Line 22: ,status_code VARCHAR2(30) := fnd_api.g_miss_char

18: entry_id NUMBER := fnd_api.g_miss_num
19: ,name VARCHAR2(50) := fnd_api.g_miss_char
20: ,txn_line_id NUMBER := fnd_api.g_miss_num
21: ,txn_line_detail_id NUMBER := fnd_api.g_miss_num
22: ,status_code VARCHAR2(30) := fnd_api.g_miss_char
23: ,batch_type VARCHAR2(30) := fnd_api.g_miss_char
24: ,description VARCHAR2(2000):= fnd_api.g_miss_char
25: ,schedule_date DATE := fnd_api.g_miss_date
26: ,start_date DATE := fnd_api.g_miss_date

Line 23: ,batch_type VARCHAR2(30) := fnd_api.g_miss_char

19: ,name VARCHAR2(50) := fnd_api.g_miss_char
20: ,txn_line_id NUMBER := fnd_api.g_miss_num
21: ,txn_line_detail_id NUMBER := fnd_api.g_miss_num
22: ,status_code VARCHAR2(30) := fnd_api.g_miss_char
23: ,batch_type VARCHAR2(30) := fnd_api.g_miss_char
24: ,description VARCHAR2(2000):= fnd_api.g_miss_char
25: ,schedule_date DATE := fnd_api.g_miss_date
26: ,start_date DATE := fnd_api.g_miss_date
27: ,end_date DATE := fnd_api.g_miss_date

Line 24: ,description VARCHAR2(2000):= fnd_api.g_miss_char

20: ,txn_line_id NUMBER := fnd_api.g_miss_num
21: ,txn_line_detail_id NUMBER := fnd_api.g_miss_num
22: ,status_code VARCHAR2(30) := fnd_api.g_miss_char
23: ,batch_type VARCHAR2(30) := fnd_api.g_miss_char
24: ,description VARCHAR2(2000):= fnd_api.g_miss_char
25: ,schedule_date DATE := fnd_api.g_miss_date
26: ,start_date DATE := fnd_api.g_miss_date
27: ,end_date DATE := fnd_api.g_miss_date
28: ,object_version_number NUMBER := fnd_api.g_miss_num

Line 25: ,schedule_date DATE := fnd_api.g_miss_date

21: ,txn_line_detail_id NUMBER := fnd_api.g_miss_num
22: ,status_code VARCHAR2(30) := fnd_api.g_miss_char
23: ,batch_type VARCHAR2(30) := fnd_api.g_miss_char
24: ,description VARCHAR2(2000):= fnd_api.g_miss_char
25: ,schedule_date DATE := fnd_api.g_miss_date
26: ,start_date DATE := fnd_api.g_miss_date
27: ,end_date DATE := fnd_api.g_miss_date
28: ,object_version_number NUMBER := fnd_api.g_miss_num
29: ,system_cascade VARCHAR2(1) := fnd_api.g_miss_char

Line 26: ,start_date DATE := fnd_api.g_miss_date

22: ,status_code VARCHAR2(30) := fnd_api.g_miss_char
23: ,batch_type VARCHAR2(30) := fnd_api.g_miss_char
24: ,description VARCHAR2(2000):= fnd_api.g_miss_char
25: ,schedule_date DATE := fnd_api.g_miss_date
26: ,start_date DATE := fnd_api.g_miss_date
27: ,end_date DATE := fnd_api.g_miss_date
28: ,object_version_number NUMBER := fnd_api.g_miss_num
29: ,system_cascade VARCHAR2(1) := fnd_api.g_miss_char
30: );

Line 27: ,end_date DATE := fnd_api.g_miss_date

23: ,batch_type VARCHAR2(30) := fnd_api.g_miss_char
24: ,description VARCHAR2(2000):= fnd_api.g_miss_char
25: ,schedule_date DATE := fnd_api.g_miss_date
26: ,start_date DATE := fnd_api.g_miss_date
27: ,end_date DATE := fnd_api.g_miss_date
28: ,object_version_number NUMBER := fnd_api.g_miss_num
29: ,system_cascade VARCHAR2(1) := fnd_api.g_miss_char
30: );
31:

Line 28: ,object_version_number NUMBER := fnd_api.g_miss_num

24: ,description VARCHAR2(2000):= fnd_api.g_miss_char
25: ,schedule_date DATE := fnd_api.g_miss_date
26: ,start_date DATE := fnd_api.g_miss_date
27: ,end_date DATE := fnd_api.g_miss_date
28: ,object_version_number NUMBER := fnd_api.g_miss_num
29: ,system_cascade VARCHAR2(1) := fnd_api.g_miss_char
30: );
31:
32: TYPE mass_edit_tbl IS TABLE OF mass_edit_rec INDEX BY BINARY_INTEGER;

Line 29: ,system_cascade VARCHAR2(1) := fnd_api.g_miss_char

25: ,schedule_date DATE := fnd_api.g_miss_date
26: ,start_date DATE := fnd_api.g_miss_date
27: ,end_date DATE := fnd_api.g_miss_date
28: ,object_version_number NUMBER := fnd_api.g_miss_num
29: ,system_cascade VARCHAR2(1) := fnd_api.g_miss_char
30: );
31:
32: TYPE mass_edit_tbl IS TABLE OF mass_edit_rec INDEX BY BINARY_INTEGER;
33:

Line 36: TXN_LINE_DETAIL_ID NUMBER := fnd_api.g_miss_num

32: TYPE mass_edit_tbl IS TABLE OF mass_edit_rec INDEX BY BINARY_INTEGER;
33:
34: TYPE mass_edit_inst_rec is RECORD
35: (
36: TXN_LINE_DETAIL_ID NUMBER := fnd_api.g_miss_num
37: ,INSTANCE_ID NUMBER := fnd_api.g_miss_num
38: ,ACTIVE_END_DATE DATE := fnd_api.g_miss_date
39: ,OBJECT_VERSION_NUMBER NUMBER := fnd_api.g_miss_num
40: );

Line 37: ,INSTANCE_ID NUMBER := fnd_api.g_miss_num

33:
34: TYPE mass_edit_inst_rec is RECORD
35: (
36: TXN_LINE_DETAIL_ID NUMBER := fnd_api.g_miss_num
37: ,INSTANCE_ID NUMBER := fnd_api.g_miss_num
38: ,ACTIVE_END_DATE DATE := fnd_api.g_miss_date
39: ,OBJECT_VERSION_NUMBER NUMBER := fnd_api.g_miss_num
40: );
41:

Line 38: ,ACTIVE_END_DATE DATE := fnd_api.g_miss_date

34: TYPE mass_edit_inst_rec is RECORD
35: (
36: TXN_LINE_DETAIL_ID NUMBER := fnd_api.g_miss_num
37: ,INSTANCE_ID NUMBER := fnd_api.g_miss_num
38: ,ACTIVE_END_DATE DATE := fnd_api.g_miss_date
39: ,OBJECT_VERSION_NUMBER NUMBER := fnd_api.g_miss_num
40: );
41:
42: TYPE mass_edit_inst_tbl IS TABLE OF mass_edit_inst_rec INDEX BY BINARY_INTEGER;

Line 39: ,OBJECT_VERSION_NUMBER NUMBER := fnd_api.g_miss_num

35: (
36: TXN_LINE_DETAIL_ID NUMBER := fnd_api.g_miss_num
37: ,INSTANCE_ID NUMBER := fnd_api.g_miss_num
38: ,ACTIVE_END_DATE DATE := fnd_api.g_miss_date
39: ,OBJECT_VERSION_NUMBER NUMBER := fnd_api.g_miss_num
40: );
41:
42: TYPE mass_edit_inst_tbl IS TABLE OF mass_edit_inst_rec INDEX BY BINARY_INTEGER;
43:

Line 46: ENTRY_ID NUMBER := FND_API.G_MISS_NUM ,

42: TYPE mass_edit_inst_tbl IS TABLE OF mass_edit_inst_rec INDEX BY BINARY_INTEGER;
43:
44: TYPE mass_edit_error_rec IS RECORD
45: (
46: ENTRY_ID NUMBER := FND_API.G_MISS_NUM ,
47: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM ,
48: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM ,
49: ERROR_TEXT VARCHAR2(2000) := FND_API.G_MISS_CHAR,
50: ERROR_CODE VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 47: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM ,

43:
44: TYPE mass_edit_error_rec IS RECORD
45: (
46: ENTRY_ID NUMBER := FND_API.G_MISS_NUM ,
47: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM ,
48: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM ,
49: ERROR_TEXT VARCHAR2(2000) := FND_API.G_MISS_CHAR,
50: ERROR_CODE VARCHAR2(1) := FND_API.G_MISS_CHAR,
51: NAME VARCHAR2(50) := FND_API.G_MISS_CHAR

Line 48: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM ,

44: TYPE mass_edit_error_rec IS RECORD
45: (
46: ENTRY_ID NUMBER := FND_API.G_MISS_NUM ,
47: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM ,
48: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM ,
49: ERROR_TEXT VARCHAR2(2000) := FND_API.G_MISS_CHAR,
50: ERROR_CODE VARCHAR2(1) := FND_API.G_MISS_CHAR,
51: NAME VARCHAR2(50) := FND_API.G_MISS_CHAR
52: );

Line 49: ERROR_TEXT VARCHAR2(2000) := FND_API.G_MISS_CHAR,

45: (
46: ENTRY_ID NUMBER := FND_API.G_MISS_NUM ,
47: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM ,
48: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM ,
49: ERROR_TEXT VARCHAR2(2000) := FND_API.G_MISS_CHAR,
50: ERROR_CODE VARCHAR2(1) := FND_API.G_MISS_CHAR,
51: NAME VARCHAR2(50) := FND_API.G_MISS_CHAR
52: );
53:

Line 50: ERROR_CODE VARCHAR2(1) := FND_API.G_MISS_CHAR,

46: ENTRY_ID NUMBER := FND_API.G_MISS_NUM ,
47: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM ,
48: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM ,
49: ERROR_TEXT VARCHAR2(2000) := FND_API.G_MISS_CHAR,
50: ERROR_CODE VARCHAR2(1) := FND_API.G_MISS_CHAR,
51: NAME VARCHAR2(50) := FND_API.G_MISS_CHAR
52: );
53:
54: TYPE mass_edit_error_tbl IS TABLE OF mass_edit_error_rec INDEX BY BINARY_INTEGER;

Line 51: NAME VARCHAR2(50) := FND_API.G_MISS_CHAR

47: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM ,
48: INSTANCE_ID NUMBER := FND_API.G_MISS_NUM ,
49: ERROR_TEXT VARCHAR2(2000) := FND_API.G_MISS_CHAR,
50: ERROR_CODE VARCHAR2(1) := FND_API.G_MISS_CHAR,
51: NAME VARCHAR2(50) := FND_API.G_MISS_CHAR
52: );
53:
54: TYPE mass_edit_error_tbl IS TABLE OF mass_edit_error_rec INDEX BY BINARY_INTEGER;
55:

Line 58: ENTRY_ID NUMBER := FND_API.G_MISS_NUM ,

54: TYPE mass_edit_error_tbl IS TABLE OF mass_edit_error_rec INDEX BY BINARY_INTEGER;
55:
56: TYPE mass_edit_sys_error_rec IS RECORD
57: (
58: ENTRY_ID NUMBER := FND_API.G_MISS_NUM ,
59: BATCH_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM ,
61: SYSTEM_ID NUMBER := FND_API.G_MISS_NUM ,
62: ERROR_TEXT VARCHAR2(2000) := FND_API.G_MISS_CHAR,

Line 59: BATCH_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,

55:
56: TYPE mass_edit_sys_error_rec IS RECORD
57: (
58: ENTRY_ID NUMBER := FND_API.G_MISS_NUM ,
59: BATCH_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM ,
61: SYSTEM_ID NUMBER := FND_API.G_MISS_NUM ,
62: ERROR_TEXT VARCHAR2(2000) := FND_API.G_MISS_CHAR,
63: ERROR_CODE VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 60: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM ,

56: TYPE mass_edit_sys_error_rec IS RECORD
57: (
58: ENTRY_ID NUMBER := FND_API.G_MISS_NUM ,
59: BATCH_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM ,
61: SYSTEM_ID NUMBER := FND_API.G_MISS_NUM ,
62: ERROR_TEXT VARCHAR2(2000) := FND_API.G_MISS_CHAR,
63: ERROR_CODE VARCHAR2(1) := FND_API.G_MISS_CHAR,
64: NAME VARCHAR2(50) := FND_API.G_MISS_CHAR

Line 61: SYSTEM_ID NUMBER := FND_API.G_MISS_NUM ,

57: (
58: ENTRY_ID NUMBER := FND_API.G_MISS_NUM ,
59: BATCH_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM ,
61: SYSTEM_ID NUMBER := FND_API.G_MISS_NUM ,
62: ERROR_TEXT VARCHAR2(2000) := FND_API.G_MISS_CHAR,
63: ERROR_CODE VARCHAR2(1) := FND_API.G_MISS_CHAR,
64: NAME VARCHAR2(50) := FND_API.G_MISS_CHAR
65: );

Line 62: ERROR_TEXT VARCHAR2(2000) := FND_API.G_MISS_CHAR,

58: ENTRY_ID NUMBER := FND_API.G_MISS_NUM ,
59: BATCH_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM ,
61: SYSTEM_ID NUMBER := FND_API.G_MISS_NUM ,
62: ERROR_TEXT VARCHAR2(2000) := FND_API.G_MISS_CHAR,
63: ERROR_CODE VARCHAR2(1) := FND_API.G_MISS_CHAR,
64: NAME VARCHAR2(50) := FND_API.G_MISS_CHAR
65: );
66:

Line 63: ERROR_CODE VARCHAR2(1) := FND_API.G_MISS_CHAR,

59: BATCH_NAME VARCHAR2(30) := FND_API.G_MISS_CHAR,
60: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM ,
61: SYSTEM_ID NUMBER := FND_API.G_MISS_NUM ,
62: ERROR_TEXT VARCHAR2(2000) := FND_API.G_MISS_CHAR,
63: ERROR_CODE VARCHAR2(1) := FND_API.G_MISS_CHAR,
64: NAME VARCHAR2(50) := FND_API.G_MISS_CHAR
65: );
66:
67: TYPE mass_edit_sys_error_tbl IS TABLE OF mass_edit_sys_error_rec INDEX BY BINARY_INTEGER;

Line 64: NAME VARCHAR2(50) := FND_API.G_MISS_CHAR

60: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM ,
61: SYSTEM_ID NUMBER := FND_API.G_MISS_NUM ,
62: ERROR_TEXT VARCHAR2(2000) := FND_API.G_MISS_CHAR,
63: ERROR_CODE VARCHAR2(1) := FND_API.G_MISS_CHAR,
64: NAME VARCHAR2(50) := FND_API.G_MISS_CHAR
65: );
66:
67: TYPE mass_edit_sys_error_tbl IS TABLE OF mass_edit_sys_error_rec INDEX BY BINARY_INTEGER;
68:

Line 71: Instance_id NUMBER := FND_API.G_MISS_NUM,

67: TYPE mass_edit_sys_error_tbl IS TABLE OF mass_edit_sys_error_rec INDEX BY BINARY_INTEGER;
68:
69: TYPE Mass_Upd_Rep_Error_Rec IS RECORD
70: (
71: Instance_id NUMBER := FND_API.G_MISS_NUM,
72: Entity_Name VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: Error_Message VARCHAR2(2000) := FND_API.G_MISS_CHAR,
74: ENTRY_ID NUMBER := FND_API.G_MISS_NUM ,
75: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM ,

Line 72: Entity_Name VARCHAR2(30) := FND_API.G_MISS_CHAR,

68:
69: TYPE Mass_Upd_Rep_Error_Rec IS RECORD
70: (
71: Instance_id NUMBER := FND_API.G_MISS_NUM,
72: Entity_Name VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: Error_Message VARCHAR2(2000) := FND_API.G_MISS_CHAR,
74: ENTRY_ID NUMBER := FND_API.G_MISS_NUM ,
75: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM ,
76: ERROR_CODE VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 73: Error_Message VARCHAR2(2000) := FND_API.G_MISS_CHAR,

69: TYPE Mass_Upd_Rep_Error_Rec IS RECORD
70: (
71: Instance_id NUMBER := FND_API.G_MISS_NUM,
72: Entity_Name VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: Error_Message VARCHAR2(2000) := FND_API.G_MISS_CHAR,
74: ENTRY_ID NUMBER := FND_API.G_MISS_NUM ,
75: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM ,
76: ERROR_CODE VARCHAR2(1) := FND_API.G_MISS_CHAR,
77: NAME VARCHAR2(50) := FND_API.G_MISS_CHAR

Line 74: ENTRY_ID NUMBER := FND_API.G_MISS_NUM ,

70: (
71: Instance_id NUMBER := FND_API.G_MISS_NUM,
72: Entity_Name VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: Error_Message VARCHAR2(2000) := FND_API.G_MISS_CHAR,
74: ENTRY_ID NUMBER := FND_API.G_MISS_NUM ,
75: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM ,
76: ERROR_CODE VARCHAR2(1) := FND_API.G_MISS_CHAR,
77: NAME VARCHAR2(50) := FND_API.G_MISS_CHAR
78: );

Line 75: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM ,

71: Instance_id NUMBER := FND_API.G_MISS_NUM,
72: Entity_Name VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: Error_Message VARCHAR2(2000) := FND_API.G_MISS_CHAR,
74: ENTRY_ID NUMBER := FND_API.G_MISS_NUM ,
75: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM ,
76: ERROR_CODE VARCHAR2(1) := FND_API.G_MISS_CHAR,
77: NAME VARCHAR2(50) := FND_API.G_MISS_CHAR
78: );
79:

Line 76: ERROR_CODE VARCHAR2(1) := FND_API.G_MISS_CHAR,

72: Entity_Name VARCHAR2(30) := FND_API.G_MISS_CHAR,
73: Error_Message VARCHAR2(2000) := FND_API.G_MISS_CHAR,
74: ENTRY_ID NUMBER := FND_API.G_MISS_NUM ,
75: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM ,
76: ERROR_CODE VARCHAR2(1) := FND_API.G_MISS_CHAR,
77: NAME VARCHAR2(50) := FND_API.G_MISS_CHAR
78: );
79:
80: TYPE Mass_Upd_Rep_Error_Tbl IS TABLE OF Mass_Upd_Rep_Error_Rec INDEX BY BINARY_INTEGER;

Line 77: NAME VARCHAR2(50) := FND_API.G_MISS_CHAR

73: Error_Message VARCHAR2(2000) := FND_API.G_MISS_CHAR,
74: ENTRY_ID NUMBER := FND_API.G_MISS_NUM ,
75: TXN_LINE_DETAIL_ID NUMBER := FND_API.G_MISS_NUM ,
76: ERROR_CODE VARCHAR2(1) := FND_API.G_MISS_CHAR,
77: NAME VARCHAR2(50) := FND_API.G_MISS_CHAR
78: );
79:
80: TYPE Mass_Upd_Rep_Error_Tbl IS TABLE OF Mass_Upd_Rep_Error_Rec INDEX BY BINARY_INTEGER;
81:

Line 85: ITEM_NUMBER VARCHAR2(40) := FND_API.G_MISS_CHAR,

81:
82: --Added for Bug 10414679
83: TYPE log_rec IS RECORD
84: (
85: ITEM_NUMBER VARCHAR2(40) := FND_API.G_MISS_CHAR,
86: EXTERNAL_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
87: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
88: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
89: QUANTITY NUMBER := FND_API.G_MISS_NUM,

Line 86: EXTERNAL_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,

82: --Added for Bug 10414679
83: TYPE log_rec IS RECORD
84: (
85: ITEM_NUMBER VARCHAR2(40) := FND_API.G_MISS_CHAR,
86: EXTERNAL_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
87: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
88: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
89: QUANTITY NUMBER := FND_API.G_MISS_NUM,
90: INTERNALLY_OWNED VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 87: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,

83: TYPE log_rec IS RECORD
84: (
85: ITEM_NUMBER VARCHAR2(40) := FND_API.G_MISS_CHAR,
86: EXTERNAL_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
87: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
88: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
89: QUANTITY NUMBER := FND_API.G_MISS_NUM,
90: INTERNALLY_OWNED VARCHAR2(1) := FND_API.G_MISS_CHAR,
91: OWNER_PARTY_NUM VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 88: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,

84: (
85: ITEM_NUMBER VARCHAR2(40) := FND_API.G_MISS_CHAR,
86: EXTERNAL_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
87: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
88: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
89: QUANTITY NUMBER := FND_API.G_MISS_NUM,
90: INTERNALLY_OWNED VARCHAR2(1) := FND_API.G_MISS_CHAR,
91: OWNER_PARTY_NUM VARCHAR2(30) := FND_API.G_MISS_CHAR,
92: OWNER_NAME VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 89: QUANTITY NUMBER := FND_API.G_MISS_NUM,

85: ITEM_NUMBER VARCHAR2(40) := FND_API.G_MISS_CHAR,
86: EXTERNAL_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
87: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
88: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
89: QUANTITY NUMBER := FND_API.G_MISS_NUM,
90: INTERNALLY_OWNED VARCHAR2(1) := FND_API.G_MISS_CHAR,
91: OWNER_PARTY_NUM VARCHAR2(30) := FND_API.G_MISS_CHAR,
92: OWNER_NAME VARCHAR2(360) := FND_API.G_MISS_CHAR,
93: SYSTEM_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR

Line 90: INTERNALLY_OWNED VARCHAR2(1) := FND_API.G_MISS_CHAR,

86: EXTERNAL_REFERENCE VARCHAR2(30) := FND_API.G_MISS_CHAR,
87: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
88: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
89: QUANTITY NUMBER := FND_API.G_MISS_NUM,
90: INTERNALLY_OWNED VARCHAR2(1) := FND_API.G_MISS_CHAR,
91: OWNER_PARTY_NUM VARCHAR2(30) := FND_API.G_MISS_CHAR,
92: OWNER_NAME VARCHAR2(360) := FND_API.G_MISS_CHAR,
93: SYSTEM_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR
94: );

Line 91: OWNER_PARTY_NUM VARCHAR2(30) := FND_API.G_MISS_CHAR,

87: SERIAL_NUMBER VARCHAR2(30) := FND_API.G_MISS_CHAR,
88: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
89: QUANTITY NUMBER := FND_API.G_MISS_NUM,
90: INTERNALLY_OWNED VARCHAR2(1) := FND_API.G_MISS_CHAR,
91: OWNER_PARTY_NUM VARCHAR2(30) := FND_API.G_MISS_CHAR,
92: OWNER_NAME VARCHAR2(360) := FND_API.G_MISS_CHAR,
93: SYSTEM_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR
94: );
95:

Line 92: OWNER_NAME VARCHAR2(360) := FND_API.G_MISS_CHAR,

88: LOT_NUMBER VARCHAR2(80) := FND_API.G_MISS_CHAR,
89: QUANTITY NUMBER := FND_API.G_MISS_NUM,
90: INTERNALLY_OWNED VARCHAR2(1) := FND_API.G_MISS_CHAR,
91: OWNER_PARTY_NUM VARCHAR2(30) := FND_API.G_MISS_CHAR,
92: OWNER_NAME VARCHAR2(360) := FND_API.G_MISS_CHAR,
93: SYSTEM_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR
94: );
95:
96: TYPE log_tbl IS TABLE OF log_rec INDEX BY BINARY_INTEGER;

Line 93: SYSTEM_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR

89: QUANTITY NUMBER := FND_API.G_MISS_NUM,
90: INTERNALLY_OWNED VARCHAR2(1) := FND_API.G_MISS_CHAR,
91: OWNER_PARTY_NUM VARCHAR2(30) := FND_API.G_MISS_CHAR,
92: OWNER_NAME VARCHAR2(360) := FND_API.G_MISS_CHAR,
93: SYSTEM_NAME VARCHAR2(50) := FND_API.G_MISS_CHAR
94: );
95:
96: TYPE log_tbl IS TABLE OF log_rec INDEX BY BINARY_INTEGER;
97:

Line 119: p_commit IN VARCHAR2 := fnd_api.g_false,

115:
116: PROCEDURE CREATE_MASS_EDIT_BATCH
117: (
118: p_api_version IN NUMBER,
119: p_commit IN VARCHAR2 := fnd_api.g_false,
120: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
121: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
122: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,
123: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,

Line 120: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

116: PROCEDURE CREATE_MASS_EDIT_BATCH
117: (
118: p_api_version IN NUMBER,
119: p_commit IN VARCHAR2 := fnd_api.g_false,
120: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
121: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
122: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,
123: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
124: px_mass_edit_inst_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_inst_tbl,

Line 121: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

117: (
118: p_api_version IN NUMBER,
119: p_commit IN VARCHAR2 := fnd_api.g_false,
120: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
121: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
122: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,
123: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
124: px_mass_edit_inst_tbl IN OUT NOCOPY csi_mass_edit_pub.mass_edit_inst_tbl,
125: px_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,

Line 143: p_commit IN VARCHAR2 := fnd_api.g_false,

139: */
140:
141: PROCEDURE UPDATE_MASS_EDIT_BATCH (
142: p_api_version IN NUMBER,
143: p_commit IN VARCHAR2 := fnd_api.g_false,
144: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
145: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
146: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,
147: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,

Line 144: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

140:
141: PROCEDURE UPDATE_MASS_EDIT_BATCH (
142: p_api_version IN NUMBER,
143: p_commit IN VARCHAR2 := fnd_api.g_false,
144: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
145: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
146: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,
147: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
148: px_mass_edit_inst_tbl IN OUT NOCOPY mass_edit_inst_tbl,

Line 145: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

141: PROCEDURE UPDATE_MASS_EDIT_BATCH (
142: p_api_version IN NUMBER,
143: p_commit IN VARCHAR2 := fnd_api.g_false,
144: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
145: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
146: px_mass_edit_rec IN OUT NOCOPY csi_mass_edit_pub.mass_edit_rec,
147: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec ,
148: px_mass_edit_inst_tbl IN OUT NOCOPY mass_edit_inst_tbl,
149: px_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,

Line 166: p_commit IN VARCHAR2 := fnd_api.g_false,

162:
163: PROCEDURE DELETE_MASS_EDIT_BATCH
164: (
165: p_api_version IN NUMBER,
166: p_commit IN VARCHAR2 := fnd_api.g_false,
167: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
168: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
169: p_mass_edit_rec IN mass_edit_rec,
170: x_return_status OUT NOCOPY VARCHAR2,

Line 167: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

163: PROCEDURE DELETE_MASS_EDIT_BATCH
164: (
165: p_api_version IN NUMBER,
166: p_commit IN VARCHAR2 := fnd_api.g_false,
167: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
168: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
169: p_mass_edit_rec IN mass_edit_rec,
170: x_return_status OUT NOCOPY VARCHAR2,
171: x_msg_count OUT NOCOPY NUMBER,

Line 168: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

164: (
165: p_api_version IN NUMBER,
166: p_commit IN VARCHAR2 := fnd_api.g_false,
167: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
168: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
169: p_mass_edit_rec IN mass_edit_rec,
170: x_return_status OUT NOCOPY VARCHAR2,
171: x_msg_count OUT NOCOPY NUMBER,
172: x_msg_data OUT NOCOPY VARCHAR2

Line 184: p_commit IN VARCHAR2 := fnd_api.g_false,

180:
181: PROCEDURE DELETE_MASS_EDIT_BATCHES
182: (
183: p_api_version IN NUMBER,
184: p_commit IN VARCHAR2 := fnd_api.g_false,
185: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
186: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
187: p_mass_edit_tbl IN mass_edit_tbl,
188: x_return_status OUT NOCOPY VARCHAR2,

Line 185: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

181: PROCEDURE DELETE_MASS_EDIT_BATCHES
182: (
183: p_api_version IN NUMBER,
184: p_commit IN VARCHAR2 := fnd_api.g_false,
185: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
186: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
187: p_mass_edit_tbl IN mass_edit_tbl,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,

Line 186: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

182: (
183: p_api_version IN NUMBER,
184: p_commit IN VARCHAR2 := fnd_api.g_false,
185: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
186: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
187: p_mass_edit_tbl IN mass_edit_tbl,
188: x_return_status OUT NOCOPY VARCHAR2,
189: x_msg_count OUT NOCOPY NUMBER,
190: x_msg_data OUT NOCOPY VARCHAR2

Line 200: p_commit IN VARCHAR2 := fnd_api.g_false,

196: */
197:
198: PROCEDURE GET_MASS_EDIT_DETAILS (
199: p_api_version IN NUMBER,
200: p_commit IN VARCHAR2 := fnd_api.g_false,
201: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
202: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
203: px_mass_edit_rec IN OUT NOCOPY mass_edit_rec,
204: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl ,

Line 201: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

197:
198: PROCEDURE GET_MASS_EDIT_DETAILS (
199: p_api_version IN NUMBER,
200: p_commit IN VARCHAR2 := fnd_api.g_false,
201: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
202: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
203: px_mass_edit_rec IN OUT NOCOPY mass_edit_rec,
204: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl ,
205: x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

Line 202: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,

198: PROCEDURE GET_MASS_EDIT_DETAILS (
199: p_api_version IN NUMBER,
200: p_commit IN VARCHAR2 := fnd_api.g_false,
201: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
202: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
203: px_mass_edit_rec IN OUT NOCOPY mass_edit_rec,
204: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl ,
205: x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
206: x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

Line 221: ,p_commit IN VARCHAR2 := fnd_api.g_false

217:
218: PROCEDURE PROCESS_SYSTEM_MASS_UPDATE
219: (
220: p_api_version IN NUMBER
221: ,p_commit IN VARCHAR2 := fnd_api.g_false
222: ,p_Entry_id IN NUMBER
223: ,p_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl
224: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
225: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl