DBA Data[Home] [Help]

APPS.ECE_SPSO_TRANS2 dependencies on ECE_SPSO_ITEM_DET_S

Line 1127: ece_spso_item_det_s.nextval

1123: TO_DATE(tbl_end(1), 'YYYY/MM/DD'),
1124: NVL(TO_NUMBER(tbl_for(1)),0),
1125: NVL(TO_NUMBER(tbl_rel(1)),0),
1126: NVL(TO_NUMBER(tbl_tot(1)),0),
1127: ece_spso_item_det_s.nextval
1128: );
1129:
1130: Bug 1742567
1131: p_communication_method,

Line 1136: ece_spso_item_det_s.currval

1132: p_transaction_type,
1133:
1134:
1135: SELECT
1136: ece_spso_item_det_s.currval
1137: INTO
1138: l_transaction_number
1139: FROM
1140: dual;

Line 1206: ece_spso_item_det_s.nextval

1202: TO_DATE(tbl_end(i), 'YYYY/MM/DD'),
1203: NVL(TO_NUMBER(tbl_for(i)),0),
1204: NVL(TO_NUMBER(tbl_rel(i)),0),
1205: NVL(TO_NUMBER(tbl_tot(i)),0),
1206: ece_spso_item_det_s.nextval
1207: );
1208:
1209: /*Bug 1742567
1210: p_communication_method,

Line 1215: ECE_SPSO_ITEM_DET_S.currval

1211: p_transaction_type,
1212: */
1213:
1214: SELECT
1215: ECE_SPSO_ITEM_DET_S.currval
1216: INTO
1217: l_transaction_number
1218: FROM
1219: dual;