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.PO_WF_PO_CHARGE_ACC dependencies on PO_WF_UTIL_PKG

Line 54: x_destination_type := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,

50: return;
51:
52: end if;
53:
54: x_destination_type := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,
55: itemkey => itemkey,
56: aname => 'DESTINATION_TYPE_CODE');
57:
58: /* Start DEBUG

Line 144: x_dest_org_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,

140: return;
141:
142: end if;
143:
144: x_dest_org_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,
145: itemkey => itemkey,
146: aname => 'DESTINATION_ORGANIZATION_ID');
147:
148: x_item_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,

Line 148: x_item_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,

144: x_dest_org_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,
145: itemkey => itemkey,
146: aname => 'DESTINATION_ORGANIZATION_ID');
147:
148: x_item_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,
149: itemkey => itemkey,
150: aname => 'ITEM_ID');
151:
152: x_dest_sub_inv := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,

Line 152: x_dest_sub_inv := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,

148: x_item_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,
149: itemkey => itemkey,
150: aname => 'ITEM_ID');
151:
152: x_dest_sub_inv := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,
153: itemkey => itemkey,
154: aname => 'DESTINATION_SUBINVENTORY');
155:
156: /* Start DEBUG

Line 188: x_vendor_site_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,

184: --GMF_transaction_accounts_PUB.get_accounts is not getting the account as per SLA setup.
185: /*
186: -- call the SLA API instead of GML_ACT_ENERATE
187: IF ( PO_GML_DB_COMMON.check_process_org(x_dest_org_id) = 'Y') THEN
188: x_vendor_site_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,
189: itemkey => itemkey,
190: aname => 'VENDOR_SITE_ID');
191:
192: if (x_dest_sub_inv is not null) then

Line 354: po_wf_util_pkg.SetItemAttrNumber ( itemtype=>itemtype,

350: result := 'COMPLETE:FAILURE';
351: return;
352: end if;
353:
354: po_wf_util_pkg.SetItemAttrNumber ( itemtype=>itemtype,
355: itemkey=>itemkey,
356: aname=>'TEMP_ACCOUNT_ID',
357: avalue=>x_account );
358: /* Start DEBUG

Line 503: x_dest_org_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,

499: return;
500:
501: end if;
502:
503: x_dest_org_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,
504: itemkey => itemkey,
505: aname => 'DESTINATION_ORGANIZATION_ID');
506:
507: x_item_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,

Line 507: x_item_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,

503: x_dest_org_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,
504: itemkey => itemkey,
505: aname => 'DESTINATION_ORGANIZATION_ID');
506:
507: x_item_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,
508: itemkey => itemkey,
509: aname => 'ITEM_ID');
510:
511: /* Start DEBUG

Line 525: x_vendor_site_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,

521: /*
522: --
523: if ( PO_GML_DB_COMMON.check_process_org(x_dest_org_id) = 'Y')
524: then
525: x_vendor_site_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,
526: itemkey => itemkey,
527: aname => 'VENDOR_SITE_ID');
528: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).account_type_code := GMF_transaction_accounts_PUB.G_CHARGE_EXP_ACCT;
529: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).item_type := '';

Line 585: po_wf_util_pkg.SetItemAttrNumber ( itemtype=>itemtype,

581:
582: return;
583: end if;
584:
585: po_wf_util_pkg.SetItemAttrNumber ( itemtype=>itemtype,
586: itemkey=>itemkey,
587: aname=>'TEMP_ACCOUNT_ID',
588: avalue=>x_expense_acc );
589:

Line 645: wip_entity_type := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,

641: return;
642:
643: end if;
644:
645: wip_entity_type := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,
646: itemkey => itemkey,
647: aname => 'WIP_ENTITY_TYPE');
648: /* Start DEBUG
649: If (debug_acc_generator_wf) then

Line 713: x_destination_organization_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,

709: return;
710:
711: end if;
712:
713: x_destination_organization_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,
714: itemkey => itemkey,
715: aname => 'DESTINATION_ORGANIZATION_ID');
716:
717: x_bom_cost_element_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,

Line 717: x_bom_cost_element_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,

713: x_destination_organization_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,
714: itemkey => itemkey,
715: aname => 'DESTINATION_ORGANIZATION_ID');
716:
717: x_bom_cost_element_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,
718: itemkey => itemkey,
719: aname => 'BOM_COST_ELEMENT_ID');
720:
721: x_wip_entity_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,

Line 721: x_wip_entity_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,

717: x_bom_cost_element_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,
718: itemkey => itemkey,
719: aname => 'BOM_COST_ELEMENT_ID');
720:
721: x_wip_entity_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,
722: itemkey => itemkey,
723: aname => 'WIP_ENTITY_ID');
724:
725: x_wip_entity_type := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,

Line 725: x_wip_entity_type := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,

721: x_wip_entity_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,
722: itemkey => itemkey,
723: aname => 'WIP_ENTITY_ID');
724:
725: x_wip_entity_type := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,
726: itemkey => itemkey,
727: aname => 'WIP_ENTITY_TYPE');
728:
729: --

Line 730: l_category_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,

726: itemkey => itemkey,
727: aname => 'WIP_ENTITY_TYPE');
728:
729: --
730: l_category_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,
731: itemkey => itemkey,
732: aname => 'CATEGORY_ID');
733: --
734:

Line 917: po_wf_util_pkg.SetItemAttrText ( itemtype=>itemtype,

913: END IF;
914:
915: if (x_wip_job_account IS NOT NULL) then
916:
917: po_wf_util_pkg.SetItemAttrText ( itemtype=>itemtype,
918: itemkey=>itemkey,
919: aname=>'TEMP_ACCOUNT_ID',
920: avalue=>x_wip_job_account );
921: result := 'COMPLETE:SUCCESS';

Line 973: x_destination_organization_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,

969: return;
970:
971: end if;
972:
973: x_destination_organization_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,
974: itemkey => itemkey,
975: aname => 'DESTINATION_ORGANIZATION_ID');
976:
977: x_bom_cost_element_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,

Line 977: x_bom_cost_element_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,

973: x_destination_organization_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,
974: itemkey => itemkey,
975: aname => 'DESTINATION_ORGANIZATION_ID');
976:
977: x_bom_cost_element_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,
978: itemkey => itemkey,
979: aname => 'BOM_COST_ELEMENT_ID');
980:
981: x_wip_entity_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,

Line 981: x_wip_entity_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,

977: x_bom_cost_element_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,
978: itemkey => itemkey,
979: aname => 'BOM_COST_ELEMENT_ID');
980:
981: x_wip_entity_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,
982: itemkey => itemkey,
983: aname => 'WIP_ENTITY_ID');
984:
985: x_wip_entity_type := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,

Line 985: x_wip_entity_type := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,

981: x_wip_entity_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,
982: itemkey => itemkey,
983: aname => 'WIP_ENTITY_ID');
984:
985: x_wip_entity_type := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,
986: itemkey => itemkey,
987: aname => 'WIP_ENTITY_TYPE');
988:
989: x_wip_repetitive_schedule_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,

Line 989: x_wip_repetitive_schedule_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,

985: x_wip_entity_type := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,
986: itemkey => itemkey,
987: aname => 'WIP_ENTITY_TYPE');
988:
989: x_wip_repetitive_schedule_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,
990: itemkey => itemkey,
991: aname => 'WIP_REPETITIVE_SCHEDULE_ID');
992:
993: /* Start DEBUG

Line 1116: po_wf_util_pkg.SetItemAttrText ( itemtype=>itemtype,

1112: END IF;
1113:
1114: if (x_wip_schedule_account IS NOT NULL) then
1115:
1116: po_wf_util_pkg.SetItemAttrText ( itemtype=>itemtype,
1117: itemkey=>itemkey,
1118: aname=>'TEMP_ACCOUNT_ID',
1119: avalue=>x_wip_schedule_account );
1120: result := 'COMPLETE:SUCCESS';

Line 1175: po_encumbrance_flag := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,

1171: return;
1172:
1173: end if;
1174:
1175: po_encumbrance_flag := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,
1176: itemkey => itemkey,
1177: aname => 'PO_ENCUMBRANCE_FLAG');
1178:
1179: x_destination_type := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,

Line 1179: x_destination_type := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,

1175: po_encumbrance_flag := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,
1176: itemkey => itemkey,
1177: aname => 'PO_ENCUMBRANCE_FLAG');
1178:
1179: x_destination_type := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,
1180: itemkey => itemkey,
1181: aname => 'DESTINATION_TYPE_CODE');
1182:
1183: --: added check for financing_flag and advance_flag in the

Line 1186: l_is_financing_flag := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,

1182:
1183: --: added check for financing_flag and advance_flag in the
1184: --setting of result below. if either flag is set to 'Y', then this is a PREPAYMENT
1185: --type distribution and we do not encumber it.
1186: l_is_financing_flag := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,
1187: itemkey => itemkey,
1188: aname => 'IS_FINANCING_DISTRIBUTION');
1189:
1190: l_is_advance_flag := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,

Line 1190: l_is_advance_flag := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,

1186: l_is_financing_flag := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,
1187: itemkey => itemkey,
1188: aname => 'IS_FINANCING_DISTRIBUTION');
1189:
1190: l_is_advance_flag := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,
1191: itemkey => itemkey,
1192: aname => 'IS_ADVANCE_DISTRIBUTION');
1193:
1194: -- Bug 5058123 Start: This code is shared between Req and PO Account Generators.

Line 1271: x_wip_entity_type := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,

1267: -- Bug 5058123: End
1268:
1269: /* For Encumbrance Project - To enable Encumbrance for Destination type Shop Floor and WIP entity type EAM */
1270:
1271: x_wip_entity_type := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,
1272: itemkey => itemkey,
1273: aname => 'WIP_ENTITY_TYPE');
1274:
1275:

Line 1406: l_account_gen_flow_type := PO_WF_UTIL_PKG.GetItemAttrText(

1402: END IF;
1403:
1404: l_progress := '020';
1405:
1406: l_account_gen_flow_type := PO_WF_UTIL_PKG.GetItemAttrText(
1407: itemtype => itemtype,
1408: itemkey => itemkey,
1409: aname => 'ACCOUNT_GENERATION_FLOW_TYPE');
1410:

Line 1470: l_is_SPS_distribution := PO_WF_UTIL_PKG.GetItemAttrText(

1466: RETURN;
1467: END IF;
1468:
1469: l_progress := '010';
1470: l_is_SPS_distribution := PO_WF_UTIL_PKG.GetItemAttrText(
1471: itemtype => itemtype,
1472: itemkey => itemkey,
1473: aname => 'IS_SPS_DISTRIBUTION');
1474:

Line 1771: l_purchasing_ou_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

1767: INTO l_temp_ou_id
1768: FROM org_organization_definitions
1769: WHERE organization_id = p_logical_inv_org_id;
1770:
1771: l_purchasing_ou_id := PO_WF_UTIL_PKG.GetItemAttrNumber(
1772: itemtype => p_itemtype,
1773: itemkey => p_itemkey,
1774: aname => 'PURCHASING_OU_ID');
1775:

Line 1833: l_item_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

1829: RETURN;
1830: END IF;
1831:
1832: l_progress := '020';
1833: l_item_id := PO_WF_UTIL_PKG.GetItemAttrNumber(
1834: itemtype => itemtype,
1835: itemkey => itemkey,
1836: aname => 'ITEM_ID');
1837:

Line 1839: l_transaction_flow_header_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

1835: itemkey => itemkey,
1836: aname => 'ITEM_ID');
1837:
1838: l_progress := '030';
1839: l_transaction_flow_header_id := PO_WF_UTIL_PKG.GetItemAttrNumber(
1840: itemtype => itemtype,
1841: itemkey => itemkey,
1842: aname => 'TRANSACTION_FLOW_HEADER_ID');
1843:

Line 1916: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype => itemtype,

1912: END IF; -- IF (l_item_id IS NULL) OR
1913: -- (is_shopfloor_enabled_item(l_item_id, l_logical_inv_org_id)) --)
1914:
1915: l_progress := '140';
1916: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype => itemtype,
1917: itemkey => itemkey,
1918: aname => 'TEMP_ACCOUNT_ID',
1919: avalue => l_SPS_charge_account_id);
1920:

Line 1987: l_dest_charge_account_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

1983: RETURN;
1984: END IF;
1985:
1986: l_progress := '020';
1987: l_dest_charge_account_id := PO_WF_UTIL_PKG.GetItemAttrNumber(
1988: itemtype => itemtype,
1989: itemkey => itemkey,
1990: aname => 'DEST_CHARGE_ACCOUNT_ID');
1991:

Line 1999: l_temp_acc_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

1995: l_dest_charge_account_id = -1 THEN
1996: result := WF_ENGINE.eng_completed || ':Y';
1997: ELSE
1998: IF (g_po_wf_debug = 'Y') THEN
1999: l_temp_acc_id := PO_WF_UTIL_PKG.GetItemAttrNumber(
2000: itemtype => itemtype,
2001: itemkey => itemkey,
2002: aname => 'TEMP_ACCOUNT_ID');
2003:

Line 2014: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype => itemtype,

2010:
2011: -- If the Dest Charge Account is not null (autocreate, or through
2012: -- Forms/PDOI), then copy it into the TEMP_ACCOUNT_ID.
2013: l_progress := '040';
2014: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype => itemtype,
2015: itemkey => itemkey,
2016: aname => 'TEMP_ACCOUNT_ID',
2017: avalue => l_dest_charge_account_id);
2018: l_progress := '050';

Line 2082: l_is_sps_distribution := PO_WF_UTIL_PKG.GetItemAttrText(

2078: --
2079: -- Return immediately if this is not an SPS distribution.
2080: --
2081: l_progress := '015';
2082: l_is_sps_distribution := PO_WF_UTIL_PKG.GetItemAttrText(
2083: itemtype => itemtype,
2084: itemkey => itemkey,
2085: aname => 'IS_SPS_DISTRIBUTION' );
2086:

Line 2094: l_pou_coa_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

2090: END IF;
2091: --
2092:
2093: l_progress := '020';
2094: l_pou_coa_id := PO_WF_UTIL_PKG.GetItemAttrNumber(
2095: itemtype => itemtype,
2096: itemkey => itemkey,
2097: aname => 'CHART_OF_ACCOUNTS_ID');
2098:

Line 2101: l_ship_to_ou_coa_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

2097: aname => 'CHART_OF_ACCOUNTS_ID');
2098:
2099: l_progress := '030';
2100: -- Use the wrapper because it is a new attribute
2101: l_ship_to_ou_coa_id := PO_WF_UTIL_PKG.GetItemAttrNumber(
2102: itemtype => itemtype,
2103: itemkey => itemkey,
2104: aname => 'SHIP_TO_OU_COA_ID');
2105:

Line 2293: l_flex_status := po_wf_util_pkg.getitemattrtext(

2289: RETURN;
2290: END IF;
2291:
2292: l_progress := '020';
2293: l_flex_status := po_wf_util_pkg.getitemattrtext(
2294: itemtype => itemtype,
2295: itemkey => itemkey,
2296: aname => 'FND_FLEX_STATUS');
2297:

Line 2311: l_account_gen_flow_type := PO_WF_UTIL_PKG.GetItemAttrText(

2307: RETURN;
2308: END IF;
2309:
2310: --Begin Bug 9645501
2311: l_account_gen_flow_type := PO_WF_UTIL_PKG.GetItemAttrText(
2312: itemtype => itemtype,
2313: itemkey => itemkey,
2314: aname => 'ACCOUNT_GENERATION_FLOW_TYPE');
2315:

Line 2318: l_coa_id := po_wf_util_pkg.getitemattrtext(

2314: aname => 'ACCOUNT_GENERATION_FLOW_TYPE');
2315:
2316:
2317: IF (l_account_gen_flow_type IS NULL OR l_account_gen_flow_type = PO_WF_BUILD_ACCOUNT_INIT.g_po_accounts) THEN
2318: l_coa_id := po_wf_util_pkg.getitemattrtext(
2319: itemtype => itemtype,
2320: itemkey => itemkey,
2321: aname => 'CHART_OF_ACCOUNTS_ID');
2322: ELSE

Line 2324: l_coa_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

2320: itemkey => itemkey,
2321: aname => 'CHART_OF_ACCOUNTS_ID');
2322: ELSE
2323:
2324: l_coa_id := PO_WF_UTIL_PKG.GetItemAttrNumber(
2325: itemtype => itemtype,
2326: itemkey => itemkey,
2327: aname => 'SHIP_TO_OU_COA_ID');
2328:

Line 2332: l_concat_segments := po_wf_util_pkg.getitemattrtext(

2328:
2329: END IF;
2330: --End Bug 9645501
2331:
2332: l_concat_segments := po_wf_util_pkg.getitemattrtext(
2333: itemtype => itemtype,
2334: itemkey => itemkey,
2335: aname => 'FND_FLEX_SEGMENTS');
2336:

Line 2337: l_validation_date := nvl(po_wf_util_pkg.getitemattrtext(

2333: itemtype => itemtype,
2334: itemkey => itemkey,
2335: aname => 'FND_FLEX_SEGMENTS');
2336:
2337: l_validation_date := nvl(po_wf_util_pkg.getitemattrtext(
2338: itemtype => itemtype,
2339: itemkey => itemkey,
2340: aname => 'ENCUMBRANCE_DATE'),
2341: SYSDATE);