DBA Data[Home] [Help]

APPS.BOM_EXPLODER_PUB dependencies on DBMS_SQL

Line 504: exclusion_t dbms_sql.varchar2_table;

500: * be set to 'Y' if a node is excluded.
501: ******************************************************************************/
502: PROCEDURE Apply_Exclusion_Rules (p_Group_Id IN NUMBER, reApply IN NUMBER DEFAULT 0)
503: IS
504: exclusion_t dbms_sql.varchar2_table;
505: BEGIN
506: SELECT '%'||d.exclusion_path || '%'
507: BULK COLLECT INTO exclusion_t
508: FROM bom_rules_b r,

Line 547: exclusion_t dbms_sql.varchar2_table;

543: * Purpose : This procedure is invoked when new explosion rules have been added
544: ******************************************************************************/
545: PROCEDURE Apply_New_Exclusion_Rules (p_bill_sequence_id IN NUMBER)
546: IS
547: exclusion_t dbms_sql.varchar2_table;
548: BEGIN
549: SELECT '%'||d.exclusion_path || '%'
550: BULK COLLECT INTO exclusion_t
551: FROM bom_rules_b r,