DBA Data[Home] [Help]

APPS.WSM_WLT_VALIDATE_PVT dependencies on WIP_ACCOUNTING_CLASSES

Line 4991: l_class_code WIP_ACCOUNTING_CLASSES.CLASS_CODE%TYPE;

4987: x_msg_data OUT NOCOPY VARCHAR2
4988: )
4989: IS
4990:
4991: l_class_code WIP_ACCOUNTING_CLASSES.CLASS_CODE%TYPE;
4992: l_class_type WIP_ACCOUNTING_CLASSES.CLASS_TYPE%TYPE; -- Bug 5487991 Added
4993: l_dummy NUMBER;
4994: l_est_scrap_account NUMBER;
4995: l_est_scrap_var_account NUMBER;

Line 4992: l_class_type WIP_ACCOUNTING_CLASSES.CLASS_TYPE%TYPE; -- Bug 5487991 Added

4988: )
4989: IS
4990:
4991: l_class_code WIP_ACCOUNTING_CLASSES.CLASS_CODE%TYPE;
4992: l_class_type WIP_ACCOUNTING_CLASSES.CLASS_TYPE%TYPE; -- Bug 5487991 Added
4993: l_dummy NUMBER;
4994: l_est_scrap_account NUMBER;
4995: l_est_scrap_var_account NUMBER;
4996: l_serial_control NUMBER;

Line 5588: from wip_accounting_classes

5584: select est_scrap_account,
5585: est_scrap_var_account
5586: into l_est_scrap_account,
5587: l_est_scrap_var_account
5588: from wip_accounting_classes
5589: where class_code = p_resulting_job_rec.class_code
5590: and organization_id = p_txn_org_id;
5591:
5592:

Line 5621: from wip_accounting_classes

5617: ELSE
5618: -- validate if such a class code exists or not.....
5619: select 1
5620: into l_dummy
5621: from wip_accounting_classes
5622: where class_code = p_resulting_job_rec.class_code
5623: and organization_id = p_txn_org_id; */
5624:
5625: END IF;

Line 5634: FROM wip_accounting_classes

5630: l_stmt_num := 150;
5631:
5632: SELECT class_type
5633: INTO l_class_type
5634: FROM wip_accounting_classes
5635: WHERE class_code = p_resulting_job_rec.class_code
5636: AND organization_id = p_txn_org_id;
5637:
5638: l_stmt_num := 160;