969:
970:
971: BEGIN
972:
973: SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
974: INTO X_Header_Id
975: FROM DUAL;
976:
977: return(X_Header_Id);
983: FUNCTION Get_Header_Id RETURN NUMBER IS
984:
985: BEGIN
986:
987: return(MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL);
988:
989: END Get_Header_Id;
990: */
991:
4319: l_stmt_num :=10;
4320: Set_Vars;
4321:
4322: --commented out by abedajna for perf. tuning
4323: /*SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
4324: **INTO X_Temp_Id
4325: **FROM DUAL;
4326: */
4327:
4436: X_Reference, /* TRANSACTION_REFERENCE */
4437: 'Y', /* PROCESS_FLAG */
4438: 'Y', /* POSTING_FLAG */
4439: -- abb X_temp_id, /* Transaction Temp Id */
4440: MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL, /* abedajna, tuning */
4441: X_revision,
4442: X_Dist_Acct_Id, /* distribution_account_id */
4443: 'WSM', /* Source Code */
4444: X_Source_Line_Id /* Transaction Id in WLSMI table */
4547:
4548: l_stmt_num :=10;
4549:
4550: --commented out by abedajna for perf. tuning
4551: /*SELECT MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
4552: **INTO X_Temp_Id
4553: **FROM DUAL;
4554: */
4555:
4656: X_Reference, /* TRANSACTION_REFERENCE */
4657: 'Y', /* PROCESS_FLAG */
4658: 'Y', /* POSTING_FLAG */
4659: -- abb X_temp_id, /* Transaction Temp Id */
4660: MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL, /* abedajna, tuning */
4661: X_Dist_Acct_Id, /* distribution account id */
4662: 'WSM', /* Source Code */
4663: X_Source_Line_Id /* Transaction Id in WLSMI table */
4664: /*BA#IIIP*/