DBA Data[Home] [Help]

APPS.ECE_SPSO_TRANS2 dependencies on ECE_SPSO_ITEM_DET_S

Line 1147: ece_spso_item_det_s.nextval

1143: TO_DATE(tbl_end(1), 'YYYY/MM/DD'),
1144: NVL(TO_NUMBER(tbl_for(1)),0),
1145: NVL(TO_NUMBER(tbl_rel(1)),0),
1146: NVL(TO_NUMBER(tbl_tot(1)),0),
1147: ece_spso_item_det_s.nextval
1148: );
1149:
1150: Bug 1742567
1151: p_communication_method,

Line 1156: ece_spso_item_det_s.currval

1152: p_transaction_type,
1153:
1154:
1155: SELECT
1156: ece_spso_item_det_s.currval
1157: INTO
1158: l_transaction_number
1159: FROM
1160: dual;

Line 1226: ece_spso_item_det_s.nextval

1222: TO_DATE(tbl_end(i), 'YYYY/MM/DD'),
1223: NVL(TO_NUMBER(tbl_for(i)),0),
1224: NVL(TO_NUMBER(tbl_rel(i)),0),
1225: NVL(TO_NUMBER(tbl_tot(i)),0),
1226: ece_spso_item_det_s.nextval
1227: );
1228:
1229: /*Bug 1742567
1230: p_communication_method,

Line 1235: ECE_SPSO_ITEM_DET_S.currval

1231: p_transaction_type,
1232: */
1233:
1234: SELECT
1235: ECE_SPSO_ITEM_DET_S.currval
1236: INTO
1237: l_transaction_number
1238: FROM
1239: dual;