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 186: x_vendor_site_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,

182:
183: -- call the SLA API instead of GML_ACT_ENERATE */
184: if ( PO_GML_DB_COMMON.check_process_org(x_dest_org_id) = 'Y')
185: then
186: x_vendor_site_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,
187: itemkey => itemkey,
188: aname => 'VENDOR_SITE_ID');
189:
190: if (x_dest_sub_inv is not null) then

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

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

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

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

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

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

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

516:
517: --
518: if ( PO_GML_DB_COMMON.check_process_org(x_dest_org_id) = 'Y')
519: then
520: x_vendor_site_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,
521: itemkey => itemkey,
522: aname => 'VENDOR_SITE_ID');
523: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).account_type_code := GMF_transaction_accounts_PUB.G_CHARGE_EXP_ACCT;
524: GMF_transaction_accounts_PUB.g_gmf_accts_tab_PUR(1).item_type := '';

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

575:
576: return;
577: end if;
578:
579: po_wf_util_pkg.SetItemAttrNumber ( itemtype=>itemtype,
580: itemkey=>itemkey,
581: aname=>'TEMP_ACCOUNT_ID',
582: avalue=>x_expense_acc );
583:

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

635: return;
636:
637: end if;
638:
639: wip_entity_type := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,
640: itemkey => itemkey,
641: aname => 'WIP_ENTITY_TYPE');
642: /* Start DEBUG
643: If (debug_acc_generator_wf) then

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

703: return;
704:
705: end if;
706:
707: x_destination_organization_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,
708: itemkey => itemkey,
709: aname => 'DESTINATION_ORGANIZATION_ID');
710:
711: x_bom_cost_element_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,

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

707: x_destination_organization_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,
708: itemkey => itemkey,
709: aname => 'DESTINATION_ORGANIZATION_ID');
710:
711: x_bom_cost_element_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,
712: itemkey => itemkey,
713: aname => 'BOM_COST_ELEMENT_ID');
714:
715: x_wip_entity_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,

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

711: x_bom_cost_element_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,
712: itemkey => itemkey,
713: aname => 'BOM_COST_ELEMENT_ID');
714:
715: x_wip_entity_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,
716: itemkey => itemkey,
717: aname => 'WIP_ENTITY_ID');
718:
719: x_wip_entity_type := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,

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

715: x_wip_entity_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,
716: itemkey => itemkey,
717: aname => 'WIP_ENTITY_ID');
718:
719: x_wip_entity_type := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,
720: itemkey => itemkey,
721: aname => 'WIP_ENTITY_TYPE');
722:
723: --

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

720: itemkey => itemkey,
721: aname => 'WIP_ENTITY_TYPE');
722:
723: --
724: l_category_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,
725: itemkey => itemkey,
726: aname => 'CATEGORY_ID');
727: --
728:

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

907: END IF;
908:
909: if (x_wip_job_account IS NOT NULL) then
910:
911: po_wf_util_pkg.SetItemAttrText ( itemtype=>itemtype,
912: itemkey=>itemkey,
913: aname=>'TEMP_ACCOUNT_ID',
914: avalue=>x_wip_job_account );
915: result := 'COMPLETE:SUCCESS';

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

963: return;
964:
965: end if;
966:
967: x_destination_organization_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,
968: itemkey => itemkey,
969: aname => 'DESTINATION_ORGANIZATION_ID');
970:
971: x_bom_cost_element_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,

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

967: x_destination_organization_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,
968: itemkey => itemkey,
969: aname => 'DESTINATION_ORGANIZATION_ID');
970:
971: x_bom_cost_element_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,
972: itemkey => itemkey,
973: aname => 'BOM_COST_ELEMENT_ID');
974:
975: x_wip_entity_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,

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

971: x_bom_cost_element_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,
972: itemkey => itemkey,
973: aname => 'BOM_COST_ELEMENT_ID');
974:
975: x_wip_entity_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,
976: itemkey => itemkey,
977: aname => 'WIP_ENTITY_ID');
978:
979: x_wip_entity_type := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,

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

975: x_wip_entity_id := po_wf_util_pkg.GetItemAttrNumber ( itemtype => itemtype,
976: itemkey => itemkey,
977: aname => 'WIP_ENTITY_ID');
978:
979: x_wip_entity_type := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,
980: itemkey => itemkey,
981: aname => 'WIP_ENTITY_TYPE');
982:
983: x_wip_repetitive_schedule_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,

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

979: x_wip_entity_type := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,
980: itemkey => itemkey,
981: aname => 'WIP_ENTITY_TYPE');
982:
983: x_wip_repetitive_schedule_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,
984: itemkey => itemkey,
985: aname => 'WIP_REPETITIVE_SCHEDULE_ID');
986:
987: /* Start DEBUG

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

1106: END IF;
1107:
1108: if (x_wip_schedule_account IS NOT NULL) then
1109:
1110: po_wf_util_pkg.SetItemAttrText ( itemtype=>itemtype,
1111: itemkey=>itemkey,
1112: aname=>'TEMP_ACCOUNT_ID',
1113: avalue=>x_wip_schedule_account );
1114: result := 'COMPLETE:SUCCESS';

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

1164: return;
1165:
1166: end if;
1167:
1168: po_encumbrance_flag := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,
1169: itemkey => itemkey,
1170: aname => 'PO_ENCUMBRANCE_FLAG');
1171:
1172: x_destination_type := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,

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

1168: po_encumbrance_flag := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,
1169: itemkey => itemkey,
1170: aname => 'PO_ENCUMBRANCE_FLAG');
1171:
1172: x_destination_type := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,
1173: itemkey => itemkey,
1174: aname => 'DESTINATION_TYPE_CODE');
1175:
1176: --: added check for financing_flag and advance_flag in the

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

1175:
1176: --: added check for financing_flag and advance_flag in the
1177: --setting of result below. if either flag is set to 'Y', then this is a PREPAYMENT
1178: --type distribution and we do not encumber it.
1179: l_is_financing_flag := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,
1180: itemkey => itemkey,
1181: aname => 'IS_FINANCING_DISTRIBUTION');
1182:
1183: l_is_advance_flag := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,

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

1179: l_is_financing_flag := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,
1180: itemkey => itemkey,
1181: aname => 'IS_FINANCING_DISTRIBUTION');
1182:
1183: l_is_advance_flag := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,
1184: itemkey => itemkey,
1185: aname => 'IS_ADVANCE_DISTRIBUTION');
1186:
1187: -- Bug 5058123 Start: This code is shared between Req and PO Account Generators.

Line 1391: l_account_gen_flow_type := PO_WF_UTIL_PKG.GetItemAttrText(

1387: END IF;
1388:
1389: l_progress := '020';
1390:
1391: l_account_gen_flow_type := PO_WF_UTIL_PKG.GetItemAttrText(
1392: itemtype => itemtype,
1393: itemkey => itemkey,
1394: aname => 'ACCOUNT_GENERATION_FLOW_TYPE');
1395:

Line 1455: l_is_SPS_distribution := PO_WF_UTIL_PKG.GetItemAttrText(

1451: RETURN;
1452: END IF;
1453:
1454: l_progress := '010';
1455: l_is_SPS_distribution := PO_WF_UTIL_PKG.GetItemAttrText(
1456: itemtype => itemtype,
1457: itemkey => itemkey,
1458: aname => 'IS_SPS_DISTRIBUTION');
1459:

Line 1756: l_purchasing_ou_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

1752: INTO l_temp_ou_id
1753: FROM org_organization_definitions
1754: WHERE organization_id = p_logical_inv_org_id;
1755:
1756: l_purchasing_ou_id := PO_WF_UTIL_PKG.GetItemAttrNumber(
1757: itemtype => p_itemtype,
1758: itemkey => p_itemkey,
1759: aname => 'PURCHASING_OU_ID');
1760:

Line 1818: l_item_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

1814: RETURN;
1815: END IF;
1816:
1817: l_progress := '020';
1818: l_item_id := PO_WF_UTIL_PKG.GetItemAttrNumber(
1819: itemtype => itemtype,
1820: itemkey => itemkey,
1821: aname => 'ITEM_ID');
1822:

Line 1824: l_transaction_flow_header_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

1820: itemkey => itemkey,
1821: aname => 'ITEM_ID');
1822:
1823: l_progress := '030';
1824: l_transaction_flow_header_id := PO_WF_UTIL_PKG.GetItemAttrNumber(
1825: itemtype => itemtype,
1826: itemkey => itemkey,
1827: aname => 'TRANSACTION_FLOW_HEADER_ID');
1828:

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

1897: END IF; -- IF (l_item_id IS NULL) OR
1898: -- (is_shopfloor_enabled_item(l_item_id, l_logical_inv_org_id)) --)
1899:
1900: l_progress := '140';
1901: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype => itemtype,
1902: itemkey => itemkey,
1903: aname => 'TEMP_ACCOUNT_ID',
1904: avalue => l_SPS_charge_account_id);
1905:

Line 1972: l_dest_charge_account_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

1968: RETURN;
1969: END IF;
1970:
1971: l_progress := '020';
1972: l_dest_charge_account_id := PO_WF_UTIL_PKG.GetItemAttrNumber(
1973: itemtype => itemtype,
1974: itemkey => itemkey,
1975: aname => 'DEST_CHARGE_ACCOUNT_ID');
1976:

Line 1984: l_temp_acc_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

1980: l_dest_charge_account_id = -1 THEN
1981: result := WF_ENGINE.eng_completed || ':Y';
1982: ELSE
1983: IF (g_po_wf_debug = 'Y') THEN
1984: l_temp_acc_id := PO_WF_UTIL_PKG.GetItemAttrNumber(
1985: itemtype => itemtype,
1986: itemkey => itemkey,
1987: aname => 'TEMP_ACCOUNT_ID');
1988:

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

1995:
1996: -- If the Dest Charge Account is not null (autocreate, or through
1997: -- Forms/PDOI), then copy it into the TEMP_ACCOUNT_ID.
1998: l_progress := '040';
1999: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype => itemtype,
2000: itemkey => itemkey,
2001: aname => 'TEMP_ACCOUNT_ID',
2002: avalue => l_dest_charge_account_id);
2003: l_progress := '050';

Line 2067: l_is_sps_distribution := PO_WF_UTIL_PKG.GetItemAttrText(

2063: --
2064: -- Return immediately if this is not an SPS distribution.
2065: --
2066: l_progress := '015';
2067: l_is_sps_distribution := PO_WF_UTIL_PKG.GetItemAttrText(
2068: itemtype => itemtype,
2069: itemkey => itemkey,
2070: aname => 'IS_SPS_DISTRIBUTION' );
2071:

Line 2079: l_pou_coa_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

2075: END IF;
2076: --
2077:
2078: l_progress := '020';
2079: l_pou_coa_id := PO_WF_UTIL_PKG.GetItemAttrNumber(
2080: itemtype => itemtype,
2081: itemkey => itemkey,
2082: aname => 'CHART_OF_ACCOUNTS_ID');
2083:

Line 2086: l_ship_to_ou_coa_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

2082: aname => 'CHART_OF_ACCOUNTS_ID');
2083:
2084: l_progress := '030';
2085: -- Use the wrapper because it is a new attribute
2086: l_ship_to_ou_coa_id := PO_WF_UTIL_PKG.GetItemAttrNumber(
2087: itemtype => itemtype,
2088: itemkey => itemkey,
2089: aname => 'SHIP_TO_OU_COA_ID');
2090:

Line 2264: l_flex_status := po_wf_util_pkg.getitemattrtext(

2260: RETURN;
2261: END IF;
2262:
2263: l_progress := '020';
2264: l_flex_status := po_wf_util_pkg.getitemattrtext(
2265: itemtype => itemtype,
2266: itemkey => itemkey,
2267: aname => 'FND_FLEX_STATUS');
2268:

Line 2281: l_coa_id := po_wf_util_pkg.getitemattrtext(

2277: result := wf_engine.eng_null;
2278: RETURN;
2279: END IF;
2280:
2281: l_coa_id := po_wf_util_pkg.getitemattrtext(
2282: itemtype => itemtype,
2283: itemkey => itemkey,
2284: aname => 'CHART_OF_ACCOUNTS_ID');
2285:

Line 2286: l_concat_segments := po_wf_util_pkg.getitemattrtext(

2282: itemtype => itemtype,
2283: itemkey => itemkey,
2284: aname => 'CHART_OF_ACCOUNTS_ID');
2285:
2286: l_concat_segments := po_wf_util_pkg.getitemattrtext(
2287: itemtype => itemtype,
2288: itemkey => itemkey,
2289: aname => 'FND_FLEX_SEGMENTS');
2290:

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

2287: itemtype => itemtype,
2288: itemkey => itemkey,
2289: aname => 'FND_FLEX_SEGMENTS');
2290:
2291: l_validation_date := nvl(po_wf_util_pkg.getitemattrtext(
2292: itemtype => itemtype,
2293: itemkey => itemkey,
2294: aname => 'ENCUMBRANCE_DATE'),
2295: SYSDATE);