APPS.PO_INQ_SV dependencies on AP_TERMS

Line 1323: PROCEDURE NAME: get_ap_terms()

1319: END;
1320:
1321: /*===========================================================================
1322:
1323: PROCEDURE NAME: get_ap_terms()
1324:
1325: ===========================================================================*/
1326: PROCEDURE get_ap_terms(x_terms_id IN number,
1327: x_ap_terms_name IN OUT NOCOPY varchar2) is

Line 1326: PROCEDURE get_ap_terms(x_terms_id IN number,

1322:
1323: PROCEDURE NAME: get_ap_terms()
1324:
1325: ===========================================================================*/
1326: PROCEDURE get_ap_terms(x_terms_id IN number,
1327: x_ap_terms_name IN OUT NOCOPY varchar2) is
1328:
1329: x_progress varchar2(3) := '000';
1330: cursor c1 is

Line 1327: x_ap_terms_name IN OUT NOCOPY varchar2) is

1323: PROCEDURE NAME: get_ap_terms()
1324:
1325: ===========================================================================*/
1326: PROCEDURE get_ap_terms(x_terms_id IN number,
1327: x_ap_terms_name IN OUT NOCOPY varchar2) is
1328:
1329: x_progress varchar2(3) := '000';
1330: cursor c1 is
1331: select name

Line 1332: from ap_terms

1328:
1329: x_progress varchar2(3) := '000';
1330: cursor c1 is
1331: select name
1332: from ap_terms
1333: where term_id = x_terms_id;
1334:
1335: BEGIN
1336:

Line 1338: FETCH c1 into x_ap_terms_name;

1334:
1335: BEGIN
1336:
1337: OPEN c1;
1338: FETCH c1 into x_ap_terms_name;
1339: IF c1%NOTFOUND then
1340: x_ap_terms_name := NULL;
1341: END IF;
1342: CLOSE c1;

Line 1340: x_ap_terms_name := NULL;

1336:
1337: OPEN c1;
1338: FETCH c1 into x_ap_terms_name;
1339: IF c1%NOTFOUND then
1340: x_ap_terms_name := NULL;
1341: END IF;
1342: CLOSE c1;
1343:
1344: EXCEPTION

Line 1346: po_message_s.sql_error('po_inq_sv.get_ap_terms', x_progress, sqlcode);

1342: CLOSE c1;
1343:
1344: EXCEPTION
1345: WHEN OTHERS THEN
1346: po_message_s.sql_error('po_inq_sv.get_ap_terms', x_progress, sqlcode);
1347: raise;
1348: END;
1349:
1350: /*===========================================================================

Line 1382: x_ap_terms_name IN OUT NOCOPY varchar2,

1378: x_wip_entity_name IN OUT NOCOPY varchar2,
1379: x_wip_line_code IN OUT NOCOPY varchar2,
1380: x_bom_resource_code IN OUT NOCOPY varchar2,
1381: x_bom_uom IN OUT NOCOPY varchar2,
1382: x_ap_terms_name IN OUT NOCOPY varchar2,
1383: x_vendor_name IN OUT NOCOPY varchar2,
1384: x_vendor_site_code IN OUT NOCOPY varchar2,
1385: --< Shared Proc FPJ Start >
1386: x_purchasing_ou_coa_id OUT NOCOPY NUMBER,

Line 1524: get_ap_terms(x_terms_id,

1520: FETCH c2 into x_terms_id;
1521: if c2%FOUND then
1522:
1523: x_progress := '005';
1524: get_ap_terms(x_terms_id,
1525: x_ap_terms_name);
1526: end if;
1527:
1528: CLOSE c2;

Line 1525: x_ap_terms_name);

1521: if c2%FOUND then
1522:
1523: x_progress := '005';
1524: get_ap_terms(x_terms_id,
1525: x_ap_terms_name);
1526: end if;
1527:
1528: CLOSE c2;
1529: