APPS.ECE_SPSO_TRANS2 dependencies on ECE_SPSO_ITEM_DET

Line 150: FROM ece_spso_item_det

146:
147: BEGIN
148: SELECT max(schedule_item_detail_sequence)
149: INTO x_item_detail_sequence
150: FROM ece_spso_item_det
151: WHERE schedule_id = rec_item.schedule_id
152: AND schedule_item_id= rec_item.schedule_item_id;
153: EXCEPTION
154: WHEN NO_DATA_FOUND THEN

Line 1096: INSERT INTO ECE_SPSO_ITEM_DET

1092: xProgress := 'SPSO2B-10-1210';
1093:
1094:
1095: --DBMS_OUTPUT.PUT_LINE('LN7 '||sqlcode);
1096: INSERT INTO ECE_SPSO_ITEM_DET
1097: (
1098: COMMUNICATION_METHOD ,
1099: TRANSACTION_TYPE ,
1100:

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 1175: INSERT INTO ECE_SPSO_ITEM_DET

1171: xProgress := 'SPSO2B-10-1230';
1172:
1173:
1174: --DBMS_OUTPUT.PUT_LINE('LN9 '||i||sqlcode);
1175: INSERT INTO ECE_SPSO_ITEM_DET
1176: (
1177: /* COMMUNICATION_METHOD ,
1178: TRANSACTION_TYPE ,
1179: */

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;