[Home] [Help]
359: l_appl_id NUMBER;
360: l_user_env_lang VARCHAR2(5);
361: CURSOR c_trx ( p_batch_id NUMBER) IS
362: SELECT trx_id
363: FROM fun_trx_headers
364: WHERE batch_id = p_batch_id;
365:
366: begin
367: --Bug: 7639191
647: l_process_complete VARCHAR2(1);
648: l_transaction_id NUMBER;
649: l_role_name VARCHAR2(30);
650: l_contact_type VARCHAR2(1);
651: l_trx_status fun_trx_headers.status%TYPE;
652: l_return_status VARCHAR2(1);
653: l_ame_admin_user VARCHAR2(30);
654: l_error_message VARCHAR2(2000);
655:
752: Function : This function is called by get_ame_contacts() and
753: get_ame_approvers functions. It returns the name of the wflow
754: role to whom FYI or approval notifications are sent out.
755: Parameters:
756: IN : p_transaction_id - fun_trx_headers.trx_id
757: p_fyi_notification - 'Y' or 'N' indicating if its FYI notification
758: p_contact_type - 'I'- Initiator or 'R'- Recipient
759: OUT : x_approvers_found - 'Y'or 'N' indicating approvers found
760: x_process_complete - 'Y'or 'N' indicating process complete
802: CURSOR c_get_orgname (p_transaction_id NUMBER,
803: p_contact_type VARCHAR2) IS
804: SELECT hzp.party_name
805: FROM hz_parties hzp,
806: fun_trx_headers trx
807: WHERE hzp.party_id = DECODE(p_contact_type,'I',trx.initiator_id,
808: trx.recipient_id)
809: AND trx.trx_id = p_transaction_id;
810:
1043: Function : This function is called to check if the user is a valid approver before enabling
1044: the 'Approve' and 'Reject' button.
1045:
1046: Parameters:
1047: IN : p_transaction_id - fun_trx_headers.trx_id
1048: OUT : Varchar2 - 'Y' implies user has access, 'N' means no access
1049: Notes : None.
1050: Testing : This function will be tested via the inbound trx UI
1051: ------------------------------------------------------------------------------*/
1146: This function is also called from within workflow to decide
1147: whether or not the user the notification is going to be sent to
1148: is a valid user or not.
1149: Parameters:
1150: IN : p_transaction_id - fun_trx_headers.trx_id
1151: p_user_id - fnd_user.userid of the person navigating
1152: to the Inbound Trx UI.
1153: p_role_name - wf_roles.name of the person the notification
1154: is being sent to or forwarded to.
1178: CURSOR c_chk_web IS
1179: SELECT 'X'
1180: FROM hz_parties p,
1181: fnd_user fu,
1182: fun_trx_headers ftrx,
1183: hz_relationships hzr,
1184: hz_org_contacts hc,
1185: hz_org_contact_roles hcr
1186: WHERE p.party_type = 'PERSON'
1202: AND ftrx.trx_id = p_transaction_id;
1203: -- End: Bug No: 5897122
1204: CURSOR c_chk_role IS
1205: SELECT 'X'
1206: FROM fun_trx_headers trx,
1207: hz_relationships rel,
1208: fnd_user wf,
1209: hz_org_contacts c,
1210: hz_org_contact_roles cr
1285: IS
1286: SELECT trx_id,
1287: recipient_id,
1288: to_le_id
1289: FROM fun_trx_headers
1290: WHERE batch_id = p_batch_id;
1291:
1292: l_initiator_id NUMBER;
1293: l_ini_le_id NUMBER;
1324: IF l_ini_invoice_flag = FND_API.G_TRUE
1325: THEN
1326: -- invoicing is required for the initator and therefore
1327: -- required for all recipients.
1328: UPDATE fun_trx_headers
1329: SET invoice_flag = 'Y'
1330: WHERE batch_id = p_batch_id;
1331: ELSE
1332: -- check if invoice is required for the recipient
1342:
1343: IF l_rec_invoice_flag = FND_API.G_TRUE
1344: THEN
1345: -- invoicing is required for the recipient
1346: UPDATE fun_trx_headers
1347: SET invoice_flag = 'Y'
1348: WHERE trx_id = l_trx_rec.trx_id;
1349: ELSE
1350: -- invoicing is not required for the recipient
1347: SET invoice_flag = 'Y'
1348: WHERE trx_id = l_trx_rec.trx_id;
1349: ELSE
1350: -- invoicing is not required for the recipient
1351: UPDATE fun_trx_headers
1352: SET invoice_flag = 'N'
1353: WHERE trx_id = l_trx_rec.trx_id;
1354: END IF; -- invoicing required for recipient
1355: END LOOP;
1356:
1357: END IF; -- invoicing enabled for inititator
1358: ELSE
1359: -- invoicing is required for this transaction
1360: UPDATE fun_trx_headers
1361: SET invoice_flag = 'Y'
1362: WHERE batch_id = p_batch_id;
1363:
1364: END IF; -- invoicing enabled for trx type