APPS.JL_ZZ_AP_LIBRARY_1_PKG dependencies on AP_PAYMENT_SCHEDULES

Line 174: from ap_payment_schedules

170: Begin
171: errcd := 0;
172: select count(*)
173: into tot_recs
174: from ap_payment_schedules
175: where invoice_id = invoiceid
176: and global_attribute11 is not null;
177: Exception
178: When Others Then

Line 576: from ap_payment_schedules

572: Begin
573: errcd := 0;
574: select count(*)
575: into tot_rec
576: from ap_payment_schedules
577: where invoice_id = invoiceid;
578: Exception
579: When Others Then
580: errcd := sqlcode;

Line 928: UPDATE AP_PAYMENT_SCHEDULES

924:
925: BEGIN
926: errcd := 0;
927:
928: UPDATE AP_PAYMENT_SCHEDULES
929: SET GLOBAL_ATTRIBUTE1 = v_inttyp,
930: GLOBAL_ATTRIBUTE2 = v_intamt,
931: GLOBAL_ATTRIBUTE3 = v_intprd,
932: GLOBAL_ATTRIBUTE4 = v_intfml,

Line 965: UPDATE AP_PAYMENT_SCHEDULES

961:
962: BEGIN
963: errcd := 0;
964:
965: UPDATE AP_PAYMENT_SCHEDULES
966: SET GLOBAL_ATTRIBUTE1 = v_inttyp,
967: GLOBAL_ATTRIBUTE2 = v_intamt,
968: GLOBAL_ATTRIBUTE3 = v_intprd,
969: GLOBAL_ATTRIBUTE4 = v_intfml,

Line 996: UPDATE AP_PAYMENT_SCHEDULES

992:
993: BEGIN
994: errcd := 0;
995:
996: UPDATE AP_PAYMENT_SCHEDULES
997: set due_date = to_date (l_due_date_char,'YYYY/MM/DD HH24:MI:SS')
998: where invoice_id = l_invoice_id
999: and payment_num = l_payment_num;
1000:

Line 1018: UPDATE AP_PAYMENT_SCHEDULES

1014:
1015: BEGIN
1016: errcd := 0;
1017:
1018: UPDATE AP_PAYMENT_SCHEDULES
1019: SET discount_date = to_date (l_discount_date_char,'YYYY/MM/DD HH24:MI:SS')
1020: WHERE invoice_id = l_invoice_id
1021: AND payment_num = l_payment_num;
1022:

Line 1039: UPDATE AP_PAYMENT_SCHEDULES

1035:
1036: BEGIN
1037: errcd := 0;
1038:
1039: UPDATE AP_PAYMENT_SCHEDULES
1040: SET due_date = to_date (l_due_date_char,'YYYY/MM/DD HH24:MI:SS')
1041: where invoice_id = l_new_invoice_id;
1042:
1043: EXCEPTION

Line 1060: UPDATE AP_PAYMENT_SCHEDULES

1056:
1057: BEGIN
1058: errcd := 0;
1059:
1060: UPDATE AP_PAYMENT_SCHEDULES
1061: SET due_date = l_new_date1
1062: WHERE invoice_id = s_invoice_id
1063: AND payment_num = s_payment_num;
1064:

Line 1082: UPDATE AP_PAYMENT_SCHEDULES

1078:
1079: BEGIN
1080: errcd := 0;
1081:
1082: UPDATE AP_PAYMENT_SCHEDULES
1083: SET discount_date = l_new_date1
1084: WHERE invoice_id = s_invoice_id
1085: AND payment_num = s_payment_num;
1086:

Line 1104: UPDATE AP_PAYMENT_SCHEDULES

1100:
1101: BEGIN
1102: errcd := 0;
1103:
1104: UPDATE AP_PAYMENT_SCHEDULES
1105: set global_attribute11 = s_bank_collection_id
1106: where invoice_id = s_invoice_id
1107: and payment_num = s_payment_num;
1108: