APPS.FUN_WF_COMMON dependencies on FUN_TRX_HEADERS

Line 362: FROM fun_trx_headers

358: l_resp_id NUMBER;
359: l_appl_id NUMBER;
360: CURSOR c_trx ( p_batch_id NUMBER) IS
361: SELECT trx_id
362: FROM fun_trx_headers
363: WHERE batch_id = p_batch_id;
364:
365: begin
366: --Bug: 7639191

Line 560: l_trx_status fun_trx_headers.status%TYPE;

556: l_process_complete VARCHAR2(1);
557: l_transaction_id NUMBER;
558: l_role_name VARCHAR2(30);
559: l_contact_type VARCHAR2(1);
560: l_trx_status fun_trx_headers.status%TYPE;
561: l_return_status VARCHAR2(1);
562: l_ame_admin_user VARCHAR2(30);
563: l_error_message VARCHAR2(2000);
564:

Line 665: IN : p_transaction_id - fun_trx_headers.trx_id

661: Function : This function is called by get_ame_contacts() and
662: get_ame_approvers functions. It returns the name of the wflow
663: role to whom FYI or approval notifications are sent out.
664: Parameters:
665: IN : p_transaction_id - fun_trx_headers.trx_id
666: p_fyi_notification - 'Y' or 'N' indicating if its FYI notification
667: p_contact_type - 'I'- Initiator or 'R'- Recipient
668: OUT : x_approvers_found - 'Y'or 'N' indicating approvers found
669: x_process_complete - 'Y'or 'N' indicating process complete

Line 715: fun_trx_headers trx

711: CURSOR c_get_orgname (p_transaction_id NUMBER,
712: p_contact_type VARCHAR2) IS
713: SELECT hzp.party_name
714: FROM hz_parties hzp,
715: fun_trx_headers trx
716: WHERE hzp.party_id = DECODE(p_contact_type,'I',trx.initiator_id,
717: trx.recipient_id)
718: AND trx.trx_id = p_transaction_id;
719:

Line 956: IN : p_transaction_id - fun_trx_headers.trx_id

952: This function is also called from within workflow to decide
953: whether or not the user the notification is going to be sent to
954: is a valid user or not.
955: Parameters:
956: IN : p_transaction_id - fun_trx_headers.trx_id
957: p_user_id - fnd_user.userid of the person navigating
958: to the Inbound Trx UI.
959: p_role_name - wf_roles.name of the person the notification
960: is being sent to or forwarded to.

Line 988: fun_trx_headers ftrx,

984: CURSOR c_chk_web IS
985: SELECT 'X'
986: FROM hz_parties p,
987: fnd_user fu,
988: fun_trx_headers ftrx,
989: hz_relationships hzr,
990: hz_org_contacts hc,
991: hz_org_contact_roles hcr
992: WHERE p.party_type = 'PERSON'

Line 1012: FROM fun_trx_headers trx,

1008: AND ftrx.trx_id = p_transaction_id;
1009: -- End: Bug No: 5897122
1010: CURSOR c_chk_role IS
1011: SELECT 'X'
1012: FROM fun_trx_headers trx,
1013: hz_relationships rel,
1014: fnd_user wf,
1015: hz_org_contacts c,
1016: hz_org_contact_roles cr

Line 1095: FROM fun_trx_headers

1091: IS
1092: SELECT trx_id,
1093: recipient_id,
1094: to_le_id
1095: FROM fun_trx_headers
1096: WHERE batch_id = p_batch_id;
1097:
1098: l_initiator_id NUMBER;
1099: l_ini_le_id NUMBER;

Line 1134: UPDATE fun_trx_headers

1130: IF l_ini_invoice_flag = FND_API.G_TRUE
1131: THEN
1132: -- invoicing is required for the initator and therefore
1133: -- required for all recipients.
1134: UPDATE fun_trx_headers
1135: SET invoice_flag = 'Y'
1136: WHERE batch_id = p_batch_id;
1137: ELSE
1138: -- check if invoice is required for the recipient

Line 1152: UPDATE fun_trx_headers

1148:
1149: IF l_rec_invoice_flag = FND_API.G_TRUE
1150: THEN
1151: -- invoicing is required for the recipient
1152: UPDATE fun_trx_headers
1153: SET invoice_flag = 'Y'
1154: WHERE trx_id = l_trx_rec.trx_id;
1155: ELSE
1156: -- invoicing is not required for the recipient

Line 1157: UPDATE fun_trx_headers

1153: SET invoice_flag = 'Y'
1154: WHERE trx_id = l_trx_rec.trx_id;
1155: ELSE
1156: -- invoicing is not required for the recipient
1157: UPDATE fun_trx_headers
1158: SET invoice_flag = 'N'
1159: WHERE trx_id = l_trx_rec.trx_id;
1160: END IF; -- invoicing required for recipient
1161: END LOOP;

Line 1166: UPDATE fun_trx_headers

1162:
1163: END IF; -- invoicing enabled for inititator
1164: ELSE
1165: -- invoicing is required for this transaction
1166: UPDATE fun_trx_headers
1167: SET invoice_flag = 'Y'
1168: WHERE batch_id = p_batch_id;
1169:
1170: END IF; -- invoicing enabled for trx type