DBA Data[Home] [Help]

APPS.PO_ACCOUNT_HELPER dependencies on FND_GLOBAL

Line 1592: , last_updated_by = FND_GLOBAL.user_id

1588: IF NVL(p_draft_id,-1) = -1 THEN --bug 16628805
1589: update po_distributions_all
1590: set code_combination_id = l_code_combination_id
1591: , last_update_date = sysdate
1592: , last_updated_by = FND_GLOBAL.user_id
1593: where po_distribution_id = l_dists.po_distribution_id;
1594: ELSE
1595: update po_distributions_draft_all
1596: set code_combination_id = l_code_combination_id

Line 1598: , last_updated_by = FND_GLOBAL.user_id

1594: ELSE
1595: update po_distributions_draft_all
1596: set code_combination_id = l_code_combination_id
1597: , last_update_date = sysdate
1598: , last_updated_by = FND_GLOBAL.user_id
1599: where po_distribution_id = l_dists.po_distribution_id
1600: and draft_id = p_draft_id;
1601: END IF;
1602: END IF;

Line 1618: , last_updated_by = FND_GLOBAL.user_id

1614: IF NVL(p_draft_id, -1) = -1 THEN --bug 16628805
1615: update po_distributions_all
1616: set budget_account_id = l_budget_account_id
1617: , last_update_date = sysdate
1618: , last_updated_by = FND_GLOBAL.user_id
1619: where po_distribution_id = l_dists.po_distribution_id;
1620: ELSE
1621: update po_distributions_draft_all
1622: set budget_account_id = l_budget_account_id

Line 1624: , last_updated_by = FND_GLOBAL.user_id

1620: ELSE
1621: update po_distributions_draft_all
1622: set budget_account_id = l_budget_account_id
1623: , last_update_date = sysdate
1624: , last_updated_by = FND_GLOBAL.user_id
1625: where po_distribution_id = l_dists.po_distribution_id
1626: and draft_id = p_draft_id;
1627: END IF;
1628: END IF;

Line 1641: , last_updated_by = FND_GLOBAL.user_id

1637: update po_distributions_all
1638: set accrual_account_id = l_accrual_account_id
1639: , variance_account_id = l_variance_account_id
1640: , last_update_date = sysdate
1641: , last_updated_by = FND_GLOBAL.user_id
1642: where po_distribution_id = l_dists.po_distribution_id;
1643: ELSE
1644: update po_distributions_draft_all
1645: set accrual_account_id = l_accrual_account_id

Line 1648: , last_updated_by = FND_GLOBAL.user_id

1644: update po_distributions_draft_all
1645: set accrual_account_id = l_accrual_account_id
1646: , variance_account_id = l_variance_account_id
1647: , last_update_date = sysdate
1648: , last_updated_by = FND_GLOBAL.user_id
1649: where po_distribution_id = l_dists.po_distribution_id
1650: and draft_id = p_draft_id;
1651: END IF;
1652:

Line 1665: , last_updated_by = FND_GLOBAL.user_id

1661: update po_distributions_all
1662: set dest_charge_account_id = l_dest_charge_account_id
1663: , dest_variance_account_id = l_dest_variance_account_id
1664: , last_update_date = sysdate
1665: , last_updated_by = FND_GLOBAL.user_id
1666: where po_distribution_id = l_dists.po_distribution_id;
1667: ELSE
1668: update po_distributions_draft_all
1669: set dest_charge_account_id = l_dest_charge_account_id

Line 1672: , last_updated_by = FND_GLOBAL.user_id

1668: update po_distributions_draft_all
1669: set dest_charge_account_id = l_dest_charge_account_id
1670: , dest_variance_account_id = l_dest_variance_account_id
1671: , last_update_date = sysdate
1672: , last_updated_by = FND_GLOBAL.user_id
1673: where po_distribution_id = l_dists.po_distribution_id
1674: and draft_id = p_draft_id;
1675: END IF;
1676: END IF;

Line 1689: , P_USER_ID => FND_GLOBAL.user_id

1685: PO_LOG.stmt(d_module,d_position,'l_fb_error_msg', l_fb_error_msg);
1686: END IF;
1687: INSERT_REPORT_AUTONOMOUS(
1688: P_MESSAGE_TEXT => l_fb_error_msg
1689: , P_USER_ID => FND_GLOBAL.user_id
1690: , P_SEQUENCE_NUM => x_sequence
1691: , P_LINE_NUM => l_dists.line_num
1692: , p_shipment_num => l_dists.shipment_num
1693: , p_distribution_num => l_dists.distribution_num

Line 1710: , P_USER_ID => FND_GLOBAL.user_id

1706: PO_LOG.stmt(d_module,d_position,'error msg', fnd_message.get_string('PO', 'PO_ALL_NO_CHARGE_FLEX'));
1707: END IF;
1708: INSERT_REPORT_AUTONOMOUS(
1709: P_MESSAGE_TEXT => NULL
1710: , P_USER_ID => FND_GLOBAL.user_id
1711: , P_SEQUENCE_NUM => x_sequence
1712: , P_LINE_NUM => l_dists.line_num
1713: , p_shipment_num => l_dists.shipment_num
1714: , p_distribution_num => l_dists.distribution_num

Line 1731: , P_USER_ID => FND_GLOBAL.user_id

1727: PO_LOG.stmt(d_module,d_position,'error msg', fnd_message.get_string('PO', 'PO_ALL_NO_ACCRUAL_FLEX'));
1728: END IF;
1729: INSERT_REPORT_AUTONOMOUS(
1730: P_MESSAGE_TEXT => NULL
1731: , P_USER_ID => FND_GLOBAL.user_id
1732: , P_SEQUENCE_NUM => x_sequence
1733: , P_LINE_NUM => l_dists.line_num
1734: , p_shipment_num => l_dists.shipment_num
1735: , p_distribution_num => l_dists.distribution_num

Line 1752: , P_USER_ID => FND_GLOBAL.user_id

1748: PO_LOG.stmt(d_module,d_position,'error msg', fnd_message.get_string('PO', 'PO_ALL_NO_BUDGET_FLEX'));
1749: END IF;
1750: INSERT_REPORT_AUTONOMOUS(
1751: P_MESSAGE_TEXT => NULL
1752: , P_USER_ID => FND_GLOBAL.user_id
1753: , P_SEQUENCE_NUM => x_sequence
1754: , P_LINE_NUM => l_dists.line_num
1755: , p_shipment_num => l_dists.shipment_num
1756: , p_distribution_num => l_dists.distribution_num

Line 1770: , P_USER_ID => FND_GLOBAL.user_id

1766:
1767: IF (NOT l_variance_success) THEN
1768: INSERT_REPORT_AUTONOMOUS(
1769: P_MESSAGE_TEXT => NULL
1770: , P_USER_ID => FND_GLOBAL.user_id
1771: , P_SEQUENCE_NUM => x_sequence
1772: , P_LINE_NUM => l_dists.line_num
1773: , p_shipment_num => l_dists.shipment_num
1774: , p_distribution_num => l_dists.distribution_num

Line 1791: , P_USER_ID => FND_GLOBAL.user_id

1787: PO_LOG.stmt(d_module,d_position,'error msg', fnd_message.get_string('PO', 'PO_ALL_NO_DEST_CHARGE_FLEX'));
1788: END IF;
1789: INSERT_REPORT_AUTONOMOUS(
1790: P_MESSAGE_TEXT => NULL
1791: , P_USER_ID => FND_GLOBAL.user_id
1792: , P_SEQUENCE_NUM => x_sequence
1793: , P_LINE_NUM => l_dists.line_num
1794: , p_shipment_num => l_dists.shipment_num
1795: , p_distribution_num => l_dists.distribution_num

Line 1812: , P_USER_ID => FND_GLOBAL.user_id

1808: PO_LOG.stmt(d_module,d_position,'error msg', fnd_message.get_string('PO', 'PO_ALL_NO_DEST_VARIANCE_FLEX'));
1809: END IF;
1810: INSERT_REPORT_AUTONOMOUS(
1811: P_MESSAGE_TEXT => NULL
1812: , P_USER_ID => FND_GLOBAL.user_id
1813: , P_SEQUENCE_NUM => x_sequence
1814: , P_LINE_NUM => l_dists.line_num
1815: , p_shipment_num => l_dists.shipment_num
1816: , p_distribution_num => l_dists.distribution_num