APPS.PA_AGREEMENT_CORE dependencies on PA_AGREEMENTS_ALL

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 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 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 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 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