DBA Data[Home] [Help]

APPS.CSI_MASS_EDIT_ENTRIES_B_PKG dependencies on DUAL

Line 40: CURSOR C2 IS SELECT CSI_MASS_EDIT_ENTRIES_S.nextval FROM sys.dual;

36: L_Transaction_Id NUMBER;
37: L_Txn_Line_Detail_Id NUMBER;
38: L_sub_type_id NUMBER;
39:
40: CURSOR C2 IS SELECT CSI_MASS_EDIT_ENTRIES_S.nextval FROM sys.dual;
41: BEGIN
42: If (px_ENTRY_ID IS NULL) OR (px_ENTRY_ID = FND_API.G_MISS_NUM) then
43: OPEN C2;
44: FETCH C2 INTO px_ENTRY_ID;

Line 50: FROM SYS.Dual;

46: End If;
47:
48: SELECT CSI_T_TRANSACTION_LINES_S.nextval
49: INTO px_TXN_LINE_ID
50: FROM SYS.Dual;
51:
52: INSERT INTO CSI_MASS_EDIT_ENTRIES_B(
53: ENTRY_ID,
54: TXN_LINE_ID,

Line 140: FROM SYS.Dual;

136: -- Inserting Non - Source Record Into CSI_T_TXN_LINE_DETAILS Table.
137:
138: SELECT CSI_T_TXN_LINE_DETAILS_S.nextval
139: INTO L_Txn_Line_Detail_Id
140: FROM SYS.Dual;
141:
142: px_TXN_LINE_DETAIL_ID := l_txn_line_detail_id;
143:
144: SELECT sub_type_id