DBA Data[Home] [Help]

APPS.BOM_EXPLODER_PUB dependencies on DBMS_SQL

Line 516: exclusion_t dbms_sql.varchar2_table;

512: * be set to 'Y' if a node is excluded.
513: ******************************************************************************/
514: PROCEDURE Apply_Exclusion_Rules (p_Group_Id IN NUMBER, reApply IN NUMBER DEFAULT 0)
515: IS
516: exclusion_t dbms_sql.varchar2_table;
517: BEGIN
518: SELECT '%'||d.exclusion_path || '%'
519: BULK COLLECT INTO exclusion_t
520: FROM bom_rules_b r,

Line 559: exclusion_t dbms_sql.varchar2_table;

555: * Purpose : This procedure is invoked when new explosion rules have been added
556: ******************************************************************************/
557: PROCEDURE Apply_New_Exclusion_Rules (p_bill_sequence_id IN NUMBER)
558: IS
559: exclusion_t dbms_sql.varchar2_table;
560: BEGIN
561: SELECT '%'||d.exclusion_path || '%'
562: BULK COLLECT INTO exclusion_t
563: FROM bom_rules_b r,