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.CSP_PACK_SERIAL_LOTS_PVT dependencies on DBMS_SQL

Line 695: dbms_sql.define_column(p_cur_get_plsl, 1, P_plsl_Rec.PACKLIST_SERIAL_LOT_ID);

691: -- Debug Message
692: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Define Columns Begins');
693:
694: -- define all columns for CSP_PACKLIST_SERIAL_LOTS_V view
695: dbms_sql.define_column(p_cur_get_plsl, 1, P_plsl_Rec.PACKLIST_SERIAL_LOT_ID);
696: dbms_sql.define_column(p_cur_get_plsl, 2, P_plsl_Rec.PACKLIST_LINE_ID);
697: dbms_sql.define_column(p_cur_get_plsl, 3, P_plsl_Rec.ORGANIZATION_ID);
698: dbms_sql.define_column(p_cur_get_plsl, 4, P_plsl_Rec.INVENTORY_ITEM_ID);
699: dbms_sql.define_column(p_cur_get_plsl, 5, P_plsl_Rec.QUANTITY);

Line 696: dbms_sql.define_column(p_cur_get_plsl, 2, P_plsl_Rec.PACKLIST_LINE_ID);

692: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Define Columns Begins');
693:
694: -- define all columns for CSP_PACKLIST_SERIAL_LOTS_V view
695: dbms_sql.define_column(p_cur_get_plsl, 1, P_plsl_Rec.PACKLIST_SERIAL_LOT_ID);
696: dbms_sql.define_column(p_cur_get_plsl, 2, P_plsl_Rec.PACKLIST_LINE_ID);
697: dbms_sql.define_column(p_cur_get_plsl, 3, P_plsl_Rec.ORGANIZATION_ID);
698: dbms_sql.define_column(p_cur_get_plsl, 4, P_plsl_Rec.INVENTORY_ITEM_ID);
699: dbms_sql.define_column(p_cur_get_plsl, 5, P_plsl_Rec.QUANTITY);
700: dbms_sql.define_column(p_cur_get_plsl, 6, P_plsl_Rec.LOT_NUMBER, 240);

Line 697: dbms_sql.define_column(p_cur_get_plsl, 3, P_plsl_Rec.ORGANIZATION_ID);

693:
694: -- define all columns for CSP_PACKLIST_SERIAL_LOTS_V view
695: dbms_sql.define_column(p_cur_get_plsl, 1, P_plsl_Rec.PACKLIST_SERIAL_LOT_ID);
696: dbms_sql.define_column(p_cur_get_plsl, 2, P_plsl_Rec.PACKLIST_LINE_ID);
697: dbms_sql.define_column(p_cur_get_plsl, 3, P_plsl_Rec.ORGANIZATION_ID);
698: dbms_sql.define_column(p_cur_get_plsl, 4, P_plsl_Rec.INVENTORY_ITEM_ID);
699: dbms_sql.define_column(p_cur_get_plsl, 5, P_plsl_Rec.QUANTITY);
700: dbms_sql.define_column(p_cur_get_plsl, 6, P_plsl_Rec.LOT_NUMBER, 240);
701: dbms_sql.define_column(p_cur_get_plsl, 7, P_plsl_Rec.SERIAL_NUMBER, 240);

Line 698: dbms_sql.define_column(p_cur_get_plsl, 4, P_plsl_Rec.INVENTORY_ITEM_ID);

694: -- define all columns for CSP_PACKLIST_SERIAL_LOTS_V view
695: dbms_sql.define_column(p_cur_get_plsl, 1, P_plsl_Rec.PACKLIST_SERIAL_LOT_ID);
696: dbms_sql.define_column(p_cur_get_plsl, 2, P_plsl_Rec.PACKLIST_LINE_ID);
697: dbms_sql.define_column(p_cur_get_plsl, 3, P_plsl_Rec.ORGANIZATION_ID);
698: dbms_sql.define_column(p_cur_get_plsl, 4, P_plsl_Rec.INVENTORY_ITEM_ID);
699: dbms_sql.define_column(p_cur_get_plsl, 5, P_plsl_Rec.QUANTITY);
700: dbms_sql.define_column(p_cur_get_plsl, 6, P_plsl_Rec.LOT_NUMBER, 240);
701: dbms_sql.define_column(p_cur_get_plsl, 7, P_plsl_Rec.SERIAL_NUMBER, 240);
702:

Line 699: dbms_sql.define_column(p_cur_get_plsl, 5, P_plsl_Rec.QUANTITY);

695: dbms_sql.define_column(p_cur_get_plsl, 1, P_plsl_Rec.PACKLIST_SERIAL_LOT_ID);
696: dbms_sql.define_column(p_cur_get_plsl, 2, P_plsl_Rec.PACKLIST_LINE_ID);
697: dbms_sql.define_column(p_cur_get_plsl, 3, P_plsl_Rec.ORGANIZATION_ID);
698: dbms_sql.define_column(p_cur_get_plsl, 4, P_plsl_Rec.INVENTORY_ITEM_ID);
699: dbms_sql.define_column(p_cur_get_plsl, 5, P_plsl_Rec.QUANTITY);
700: dbms_sql.define_column(p_cur_get_plsl, 6, P_plsl_Rec.LOT_NUMBER, 240);
701: dbms_sql.define_column(p_cur_get_plsl, 7, P_plsl_Rec.SERIAL_NUMBER, 240);
702:
703: -- Debug Message

Line 700: dbms_sql.define_column(p_cur_get_plsl, 6, P_plsl_Rec.LOT_NUMBER, 240);

696: dbms_sql.define_column(p_cur_get_plsl, 2, P_plsl_Rec.PACKLIST_LINE_ID);
697: dbms_sql.define_column(p_cur_get_plsl, 3, P_plsl_Rec.ORGANIZATION_ID);
698: dbms_sql.define_column(p_cur_get_plsl, 4, P_plsl_Rec.INVENTORY_ITEM_ID);
699: dbms_sql.define_column(p_cur_get_plsl, 5, P_plsl_Rec.QUANTITY);
700: dbms_sql.define_column(p_cur_get_plsl, 6, P_plsl_Rec.LOT_NUMBER, 240);
701: dbms_sql.define_column(p_cur_get_plsl, 7, P_plsl_Rec.SERIAL_NUMBER, 240);
702:
703: -- Debug Message
704: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Define Columns Ends');

Line 701: dbms_sql.define_column(p_cur_get_plsl, 7, P_plsl_Rec.SERIAL_NUMBER, 240);

697: dbms_sql.define_column(p_cur_get_plsl, 3, P_plsl_Rec.ORGANIZATION_ID);
698: dbms_sql.define_column(p_cur_get_plsl, 4, P_plsl_Rec.INVENTORY_ITEM_ID);
699: dbms_sql.define_column(p_cur_get_plsl, 5, P_plsl_Rec.QUANTITY);
700: dbms_sql.define_column(p_cur_get_plsl, 6, P_plsl_Rec.LOT_NUMBER, 240);
701: dbms_sql.define_column(p_cur_get_plsl, 7, P_plsl_Rec.SERIAL_NUMBER, 240);
702:
703: -- Debug Message
704: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Define Columns Ends');
705: END Define_Columns;

Line 718: dbms_sql.column_value(p_cur_get_plsl, 1, X_plsl_Rec.ROW_ID);

714: -- Debug Message
715: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Begins');
716:
717: -- get all column values for CSP_PACKLIST_SERIAL_LOTS_V table
718: dbms_sql.column_value(p_cur_get_plsl, 1, X_plsl_Rec.ROW_ID);
719: dbms_sql.column_value(p_cur_get_plsl, 2, X_plsl_Rec.PACKLIST_SERIAL_LOT_ID);
720: dbms_sql.column_value(p_cur_get_plsl, 3, X_plsl_Rec.PACKLIST_LINE_ID);
721: dbms_sql.column_value(p_cur_get_plsl, 4, X_plsl_Rec.ORGANIZATION_ID);
722: dbms_sql.column_value(p_cur_get_plsl, 5, X_plsl_Rec.INVENTORY_ITEM_ID);

Line 719: dbms_sql.column_value(p_cur_get_plsl, 2, X_plsl_Rec.PACKLIST_SERIAL_LOT_ID);

715: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Begins');
716:
717: -- get all column values for CSP_PACKLIST_SERIAL_LOTS_V table
718: dbms_sql.column_value(p_cur_get_plsl, 1, X_plsl_Rec.ROW_ID);
719: dbms_sql.column_value(p_cur_get_plsl, 2, X_plsl_Rec.PACKLIST_SERIAL_LOT_ID);
720: dbms_sql.column_value(p_cur_get_plsl, 3, X_plsl_Rec.PACKLIST_LINE_ID);
721: dbms_sql.column_value(p_cur_get_plsl, 4, X_plsl_Rec.ORGANIZATION_ID);
722: dbms_sql.column_value(p_cur_get_plsl, 5, X_plsl_Rec.INVENTORY_ITEM_ID);
723: dbms_sql.column_value(p_cur_get_plsl, 6, X_plsl_Rec.QUANTITY);

Line 720: dbms_sql.column_value(p_cur_get_plsl, 3, X_plsl_Rec.PACKLIST_LINE_ID);

716:
717: -- get all column values for CSP_PACKLIST_SERIAL_LOTS_V table
718: dbms_sql.column_value(p_cur_get_plsl, 1, X_plsl_Rec.ROW_ID);
719: dbms_sql.column_value(p_cur_get_plsl, 2, X_plsl_Rec.PACKLIST_SERIAL_LOT_ID);
720: dbms_sql.column_value(p_cur_get_plsl, 3, X_plsl_Rec.PACKLIST_LINE_ID);
721: dbms_sql.column_value(p_cur_get_plsl, 4, X_plsl_Rec.ORGANIZATION_ID);
722: dbms_sql.column_value(p_cur_get_plsl, 5, X_plsl_Rec.INVENTORY_ITEM_ID);
723: dbms_sql.column_value(p_cur_get_plsl, 6, X_plsl_Rec.QUANTITY);
724: dbms_sql.column_value(p_cur_get_plsl, 7, X_plsl_Rec.LOT_NUMBER);

Line 721: dbms_sql.column_value(p_cur_get_plsl, 4, X_plsl_Rec.ORGANIZATION_ID);

717: -- get all column values for CSP_PACKLIST_SERIAL_LOTS_V table
718: dbms_sql.column_value(p_cur_get_plsl, 1, X_plsl_Rec.ROW_ID);
719: dbms_sql.column_value(p_cur_get_plsl, 2, X_plsl_Rec.PACKLIST_SERIAL_LOT_ID);
720: dbms_sql.column_value(p_cur_get_plsl, 3, X_plsl_Rec.PACKLIST_LINE_ID);
721: dbms_sql.column_value(p_cur_get_plsl, 4, X_plsl_Rec.ORGANIZATION_ID);
722: dbms_sql.column_value(p_cur_get_plsl, 5, X_plsl_Rec.INVENTORY_ITEM_ID);
723: dbms_sql.column_value(p_cur_get_plsl, 6, X_plsl_Rec.QUANTITY);
724: dbms_sql.column_value(p_cur_get_plsl, 7, X_plsl_Rec.LOT_NUMBER);
725: dbms_sql.column_value(p_cur_get_plsl, 8, X_plsl_Rec.SERIAL_NUMBER);

Line 722: dbms_sql.column_value(p_cur_get_plsl, 5, X_plsl_Rec.INVENTORY_ITEM_ID);

718: dbms_sql.column_value(p_cur_get_plsl, 1, X_plsl_Rec.ROW_ID);
719: dbms_sql.column_value(p_cur_get_plsl, 2, X_plsl_Rec.PACKLIST_SERIAL_LOT_ID);
720: dbms_sql.column_value(p_cur_get_plsl, 3, X_plsl_Rec.PACKLIST_LINE_ID);
721: dbms_sql.column_value(p_cur_get_plsl, 4, X_plsl_Rec.ORGANIZATION_ID);
722: dbms_sql.column_value(p_cur_get_plsl, 5, X_plsl_Rec.INVENTORY_ITEM_ID);
723: dbms_sql.column_value(p_cur_get_plsl, 6, X_plsl_Rec.QUANTITY);
724: dbms_sql.column_value(p_cur_get_plsl, 7, X_plsl_Rec.LOT_NUMBER);
725: dbms_sql.column_value(p_cur_get_plsl, 8, X_plsl_Rec.SERIAL_NUMBER);
726:

Line 723: dbms_sql.column_value(p_cur_get_plsl, 6, X_plsl_Rec.QUANTITY);

719: dbms_sql.column_value(p_cur_get_plsl, 2, X_plsl_Rec.PACKLIST_SERIAL_LOT_ID);
720: dbms_sql.column_value(p_cur_get_plsl, 3, X_plsl_Rec.PACKLIST_LINE_ID);
721: dbms_sql.column_value(p_cur_get_plsl, 4, X_plsl_Rec.ORGANIZATION_ID);
722: dbms_sql.column_value(p_cur_get_plsl, 5, X_plsl_Rec.INVENTORY_ITEM_ID);
723: dbms_sql.column_value(p_cur_get_plsl, 6, X_plsl_Rec.QUANTITY);
724: dbms_sql.column_value(p_cur_get_plsl, 7, X_plsl_Rec.LOT_NUMBER);
725: dbms_sql.column_value(p_cur_get_plsl, 8, X_plsl_Rec.SERIAL_NUMBER);
726:
727: -- Debug Message

Line 724: dbms_sql.column_value(p_cur_get_plsl, 7, X_plsl_Rec.LOT_NUMBER);

720: dbms_sql.column_value(p_cur_get_plsl, 3, X_plsl_Rec.PACKLIST_LINE_ID);
721: dbms_sql.column_value(p_cur_get_plsl, 4, X_plsl_Rec.ORGANIZATION_ID);
722: dbms_sql.column_value(p_cur_get_plsl, 5, X_plsl_Rec.INVENTORY_ITEM_ID);
723: dbms_sql.column_value(p_cur_get_plsl, 6, X_plsl_Rec.QUANTITY);
724: dbms_sql.column_value(p_cur_get_plsl, 7, X_plsl_Rec.LOT_NUMBER);
725: dbms_sql.column_value(p_cur_get_plsl, 8, X_plsl_Rec.SERIAL_NUMBER);
726:
727: -- Debug Message
728: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Ends');

Line 725: dbms_sql.column_value(p_cur_get_plsl, 8, X_plsl_Rec.SERIAL_NUMBER);

721: dbms_sql.column_value(p_cur_get_plsl, 4, X_plsl_Rec.ORGANIZATION_ID);
722: dbms_sql.column_value(p_cur_get_plsl, 5, X_plsl_Rec.INVENTORY_ITEM_ID);
723: dbms_sql.column_value(p_cur_get_plsl, 6, X_plsl_Rec.QUANTITY);
724: dbms_sql.column_value(p_cur_get_plsl, 7, X_plsl_Rec.LOT_NUMBER);
725: dbms_sql.column_value(p_cur_get_plsl, 8, X_plsl_Rec.SERIAL_NUMBER);
726:
727: -- Debug Message
728: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Get Column Values Ends');
729: END Get_Column_Values;

Line 790: DBMS_SQL.BIND_VARIABLE(p_cur_get_plsl, ':p_PACKLIST_SERIAL_LOT_ID', P_plsl_Rec.PACKLIST_SERIAL_LOT_ID);

786: -- The following example applies to all columns,
787: -- developers can copy and paste them.
788: IF( (P_plsl_Rec.PACKLIST_SERIAL_LOT_ID IS NOT NULL) AND (P_plsl_Rec.PACKLIST_SERIAL_LOT_ID <> FND_API.G_MISS_NUM) )
789: THEN
790: DBMS_SQL.BIND_VARIABLE(p_cur_get_plsl, ':p_PACKLIST_SERIAL_LOT_ID', P_plsl_Rec.PACKLIST_SERIAL_LOT_ID);
791: END IF;
792:
793: -- Debug Message
794: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Private API: Bind Variables Ends');