eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_AGREEMENT_CORE dependencies on PA_AGREEMENTS

Line 247: from pa_agreements p

243: not_unique number;
244:
245: BEGIN
246: select 1 into not_unique
247: from pa_agreements p
248: where p.customer_id = p_customer_id
249: and p.agreement_num = p_agreement_num
250: and p.agreement_type = p_agreement_type;
251:

Line 283: FROM PA_AGREEMENTS_ALL A

279: RETURN VARCHAR2
280: IS
281: CURSOR c IS
282: SELECT 1
283: FROM PA_AGREEMENTS_ALL A
284: WHERE A.pm_agreement_reference = p_agreement_reference;
285: l_row c%ROWTYPE;
286: BEGIN
287: -- dbms_output.put_line('PA_AGREEMENT_CORE.CHECK_VALID_AGREEMENT_REF');

Line 319: FROM PA_AGREEMENTS_ALL A

315: RETURN VARCHAR2
316: IS
317: CURSOR c IS
318: SELECT 1
319: FROM PA_AGREEMENTS_ALL A
320: WHERE A.agreement_id = p_agreement_id;
321: l_row c%ROWTYPE;
322: BEGIN
323: OPEN C;

Line 720: FROM PA_AGREEMENTS_ALL A

716:
717: CURSOR c1
718: IS
719: SELECT A.customer_id
720: FROM PA_AGREEMENTS_ALL A
721: WHERE A.agreement_id = (SELECT f.agreement_id
722: FROM PA_PROJECT_FUNDINGS f
723: WHERE f.project_funding_id = p_funding_id);
724:

Line 728: FROM PA_AGREEMENTS_ALL A

724:
725: CURSOR c2
726: IS
727: SELECT A.customer_id
728: FROM PA_AGREEMENTS_ALL A
729: WHERE A.agreement_id = (SELECT f.agreement_id
730: FROM PA_PROJECT_FUNDINGS f
731: WHERE f.pm_funding_reference = p_funding_reference);
732:

Line 767: | Description : This procedure will insert one row in to PA_AGREEMENTS_ALL

763:
764: /*============================================================================+
765: | Name : create_agreement
766: | Type : PROCEDURE
767: | Description : This procedure will insert one row in to PA_AGREEMENTS_ALL
768: | History :
769: | 15-MAY-2000 Created Nikhil Mishra.
770: | 07-SEP-2001 Modified Srividya
771: | Added all new columns used in MCB2

Line 855: pa_agreements_pkg.insert_row(

851: raise no_data_found;
852: end if;
853: /* End of change for Shared Services*/
854:
855: pa_agreements_pkg.insert_row(
856: x_rowid => p_rowid,
857: x_agreement_id => p_agreement_id,
858: x_customer_id => p_customer_id,
859: x_agreement_num => p_agreement_num,

Line 922: | Description : This procedure will update one row in to PA_AGREEMENTS_ALL

918:
919: /*============================================================================+
920: | Name : update_agreement
921: | Type : PROCEDURE
922: | Description : This procedure will update one row in to PA_AGREEMENTS_ALL
923: | History :
924: | 15-MAY-2000 Created Nikhil Mishra.
925: | 07-SEP-2001 Modified Srividya
926: | Added all new columns used in MCB2

Line 984: FROM PA_AGREEMENTS_ALL

980: is
981: CURSOR C IS
982: SELECT rowid,agreement_currency_code,
983: owning_organization_id, invoice_limit_flag
984: FROM PA_AGREEMENTS_ALL
985: WHERE agreement_id = p_agreement_id;
986: agr_rec C%ROWTYPE;
987:
988: l_agreement_currency_code VARCHAR2(30);

Line 1008: pa_agreements_pkg.update_row(

1004: else
1005: l_invoice_limit_flag := p_invoice_limit_flag;
1006: end if;
1007:
1008: pa_agreements_pkg.update_row(
1009: x_rowid => agr_rec.rowid,
1010: x_agreement_id => p_agreement_id,
1011: x_customer_id => p_customer_id,
1012: x_agreement_num => p_agreement_num,

Line 1068: | Description : This procedure will delete one row from PA_AGREEMENTS_ALL

1064:
1065: /*============================================================================+
1066: | Name : delete_agreement
1067: | Type : PROCEDURE
1068: | Description : This procedure will delete one row from PA_AGREEMENTS_ALL
1069: | History :
1070: | 15-MAY-2000 Created Nikhil Mishra.
1071: +============================================================================*/
1072: procedure delete_agreement(p_agreement_id IN NUMBER)

Line 1076: FROM PA_AGREEMENTS

1072: procedure delete_agreement(p_agreement_id IN NUMBER)
1073: is
1074: CURSOR C IS
1075: SELECT rowid
1076: FROM PA_AGREEMENTS
1077: WHERE agreement_id = p_agreement_id;
1078: agr_row_id VARCHAR2(2000);
1079: BEGIN
1080: OPEN C;

Line 1083: pa_agreements_pkg.delete_row(agr_row_id);

1079: BEGIN
1080: OPEN C;
1081: FETCH C INTO agr_row_id;
1082: IF C%FOUND THEN
1083: pa_agreements_pkg.delete_row(agr_row_id);
1084: END IF;
1085: CLOSE C;
1086: END delete_agreement;
1087:

Line 1092: | Description : This procedure will lock one row in to PA_AGREEMENTS_ALL

1088:
1089: /*============================================================================+
1090: | Name : lock
1091: | Type : PROCEDURE
1092: | Description : This procedure will lock one row in to PA_AGREEMENTS_ALL
1093: | History :
1094: | 15-MAY-2000 Created Nikhil Mishra.
1095: | 07-SEP-2001 Modified Srividya
1096: | Added all new columns used in MCB2

Line 1151: FROM PA_AGREEMENTS

1147: attribute22,
1148: attribute23,
1149: attribute24,
1150: attribute25
1151: FROM PA_AGREEMENTS
1152: WHERE agreement_id = p_agreement_id;
1153: agr_rec C%ROWTYPE;
1154: BEGIN
1155: OPEN C;

Line 1158: pa_agreements_pkg.lock_row (

1154: BEGIN
1155: OPEN C;
1156: FETCH C INTO agr_rec;
1157: IF C%FOUND THEN
1158: pa_agreements_pkg.lock_row (
1159: x_rowid => agr_rec.rowid,
1160: x_agreement_id => agr_rec.agreement_id,
1161: x_customer_id => agr_rec.customer_id,
1162: x_agreement_num => agr_rec.agreement_num,

Line 1307: FROM pa_agreements_all

1303: RETURN VARCHAR2 IS
1304: l_currency_code VARCHAR2(30);
1305: BEGIN
1306: SELECT agreement_currency_code INTO l_currency_code
1307: FROM pa_agreements_all
1308: WHERE agreement_id = p_agreement_id;
1309: RETURN (l_currency_code);
1310: EXCEPTION
1311: WHEN NO_DATA_FOUND THEN