916: r_new.draft_invoice_num ,
917: ln_organization_id ,
918: ln_location_id ,
919: sysdate ,
920: fnd_global.user_id ,
921: sysdate ,
922: fnd_global.user_id ,
923: fnd_global.login_id ,
924: ln_parent_draft_invoice_id
918: ln_location_id ,
919: sysdate ,
920: fnd_global.user_id ,
921: sysdate ,
922: fnd_global.user_id ,
923: fnd_global.login_id ,
924: ln_parent_draft_invoice_id
925: ) ;
926: end if ;
919: sysdate ,
920: fnd_global.user_id ,
921: sysdate ,
922: fnd_global.user_id ,
923: fnd_global.login_id ,
924: ln_parent_draft_invoice_id
925: ) ;
926: end if ;
927: --step3 -- generate line id from sequence generated number ;
957: r_new.amount ,
958: null ,
959: ln_tax_category_id ,
960: sysdate ,
961: fnd_global.user_id ,
962: sysdate ,
963: fnd_global.user_id ,
964: fnd_global.login_id ,
965: lv_service_type_code ,
959: ln_tax_category_id ,
960: sysdate ,
961: fnd_global.user_id ,
962: sysdate ,
963: fnd_global.user_id ,
964: fnd_global.login_id ,
965: lv_service_type_code ,
966: pkg_global_type.ln_draft_invoice_id ,
967: pkg_global_type.ln_draft_invoice_line_id
960: sysdate ,
961: fnd_global.user_id ,
962: sysdate ,
963: fnd_global.user_id ,
964: fnd_global.login_id ,
965: lv_service_type_code ,
966: pkg_global_type.ln_draft_invoice_id ,
967: pkg_global_type.ln_draft_invoice_line_id
968: );
1086: j1.precedence_8 ,
1087: j1.precedence_9 ,
1088: j1.precedence_10 ,
1089: sysdate ,
1090: fnd_global.user_id ,
1091: sysdate ,
1092: fnd_global.user_id ,
1093: fnd_global.login_id
1094: from jai_cmn_document_taxes j1 , JAI_CMN_TAXES_ALL j2
1088: j1.precedence_10 ,
1089: sysdate ,
1090: fnd_global.user_id ,
1091: sysdate ,
1092: fnd_global.user_id ,
1093: fnd_global.login_id
1094: from jai_cmn_document_taxes j1 , JAI_CMN_TAXES_ALL j2
1095: where j1.source_doc_id = pkg_global_type.ln_draft_invoice_id and
1096: j1.source_doc_line_id = pkg_global_type.ln_draft_invoice_line_id and
1089: sysdate ,
1090: fnd_global.user_id ,
1091: sysdate ,
1092: fnd_global.user_id ,
1093: fnd_global.login_id
1094: from jai_cmn_document_taxes j1 , JAI_CMN_TAXES_ALL j2
1095: where j1.source_doc_id = pkg_global_type.ln_draft_invoice_id and
1096: j1.source_doc_line_id = pkg_global_type.ln_draft_invoice_line_id and
1097: j1.source_doc_type = jai_constants.pa_draft_invoice and
1175: P_VENDOR_ID => NULL,
1176: P_CURRENCY => LV_INV_CURRENCY_CODE,
1177: P_CURRENCY_CONV_FACTOR => LN_INV_EXCHANGE_RATE, -- FOR MULTI CURRENCT SUPPORT
1178: P_CREATION_DATE => SYSDATE,
1179: P_CREATED_BY => FND_GLOBAL.USER_ID,
1180: P_LAST_UPDATE_DATE => SYSDATE,
1181: P_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1182: P_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
1183: P_SOURCE_TRX_TYPE => JAI_CONSTANTS.PA_DRAFT_INVOICE,
1177: P_CURRENCY_CONV_FACTOR => LN_INV_EXCHANGE_RATE, -- FOR MULTI CURRENCT SUPPORT
1178: P_CREATION_DATE => SYSDATE,
1179: P_CREATED_BY => FND_GLOBAL.USER_ID,
1180: P_LAST_UPDATE_DATE => SYSDATE,
1181: P_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1182: P_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
1183: P_SOURCE_TRX_TYPE => JAI_CONSTANTS.PA_DRAFT_INVOICE,
1184: P_SOURCE_TABLE_NAME => 'JAI_PA_DRAFT_INVOICE_LINES',
1185: P_ACTION => JAI_CONSTANTS.DEFAULT_TAXES
1178: P_CREATION_DATE => SYSDATE,
1179: P_CREATED_BY => FND_GLOBAL.USER_ID,
1180: P_LAST_UPDATE_DATE => SYSDATE,
1181: P_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1182: P_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
1183: P_SOURCE_TRX_TYPE => JAI_CONSTANTS.PA_DRAFT_INVOICE,
1184: P_SOURCE_TABLE_NAME => 'JAI_PA_DRAFT_INVOICE_LINES',
1185: P_ACTION => JAI_CONSTANTS.DEFAULT_TAXES
1186: ) ;
1324: P_VENDOR_ID => NULL,
1325: P_CURRENCY => LV_INV_CURRENCY_CODE,
1326: P_CURRENCY_CONV_FACTOR => LN_INV_EXCHANGE_RATE, -- for multi currenct support
1327: P_CREATION_DATE => SYSDATE,
1328: P_CREATED_BY => FND_GLOBAL.USER_ID,
1329: P_LAST_UPDATE_DATE => SYSDATE,
1330: P_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1331: P_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
1332: P_SOURCE_TRX_TYPE => JAI_CONSTANTS.PA_DRAFT_INVOICE,
1326: P_CURRENCY_CONV_FACTOR => LN_INV_EXCHANGE_RATE, -- for multi currenct support
1327: P_CREATION_DATE => SYSDATE,
1328: P_CREATED_BY => FND_GLOBAL.USER_ID,
1329: P_LAST_UPDATE_DATE => SYSDATE,
1330: P_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1331: P_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
1332: P_SOURCE_TRX_TYPE => JAI_CONSTANTS.PA_DRAFT_INVOICE,
1333: P_SOURCE_TABLE_NAME => 'JAI_PA_DRAFT_INVOICE_LINES',
1334: P_ACTION => JAI_CONSTANTS.RECALCULATE_TAXES
1327: P_CREATION_DATE => SYSDATE,
1328: P_CREATED_BY => FND_GLOBAL.USER_ID,
1329: P_LAST_UPDATE_DATE => SYSDATE,
1330: P_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
1331: P_LAST_UPDATE_LOGIN => FND_GLOBAL.LOGIN_ID,
1332: P_SOURCE_TRX_TYPE => JAI_CONSTANTS.PA_DRAFT_INVOICE,
1333: P_SOURCE_TABLE_NAME => 'JAI_PA_DRAFT_INVOICE_LINES',
1334: P_ACTION => JAI_CONSTANTS.RECALCULATE_TAXES
1335: ) ;