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

Line 682: dbms_sql.define_column(p_cur_get_rs_camp, 1, P_rs_camp_Rec.RS_CAMPAIGN_ID);

678: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: Define Columns Begins');
679:
680:
681: -- define all columns for AST_TEST view
682: dbms_sql.define_column(p_cur_get_rs_camp, 1, P_rs_camp_Rec.RS_CAMPAIGN_ID);
683: dbms_sql.define_column(p_cur_get_rs_camp, 2, P_rs_camp_Rec.RESOURCE_ID);
684: dbms_sql.define_column(p_cur_get_rs_camp, 3, P_rs_camp_Rec.CAMPAIGN_ID);
685: dbms_sql.define_column(p_cur_get_rs_camp, 4, P_rs_camp_Rec.START_DATE);
686: dbms_sql.define_column(p_cur_get_rs_camp, 5, P_rs_camp_Rec.END_DATE);

Line 683: dbms_sql.define_column(p_cur_get_rs_camp, 2, P_rs_camp_Rec.RESOURCE_ID);

679:
680:
681: -- define all columns for AST_TEST view
682: dbms_sql.define_column(p_cur_get_rs_camp, 1, P_rs_camp_Rec.RS_CAMPAIGN_ID);
683: dbms_sql.define_column(p_cur_get_rs_camp, 2, P_rs_camp_Rec.RESOURCE_ID);
684: dbms_sql.define_column(p_cur_get_rs_camp, 3, P_rs_camp_Rec.CAMPAIGN_ID);
685: dbms_sql.define_column(p_cur_get_rs_camp, 4, P_rs_camp_Rec.START_DATE);
686: dbms_sql.define_column(p_cur_get_rs_camp, 5, P_rs_camp_Rec.END_DATE);
687: dbms_sql.define_column(p_cur_get_rs_camp, 6, P_rs_camp_Rec.STATUS, 1);

Line 684: dbms_sql.define_column(p_cur_get_rs_camp, 3, P_rs_camp_Rec.CAMPAIGN_ID);

680:
681: -- define all columns for AST_TEST view
682: dbms_sql.define_column(p_cur_get_rs_camp, 1, P_rs_camp_Rec.RS_CAMPAIGN_ID);
683: dbms_sql.define_column(p_cur_get_rs_camp, 2, P_rs_camp_Rec.RESOURCE_ID);
684: dbms_sql.define_column(p_cur_get_rs_camp, 3, P_rs_camp_Rec.CAMPAIGN_ID);
685: dbms_sql.define_column(p_cur_get_rs_camp, 4, P_rs_camp_Rec.START_DATE);
686: dbms_sql.define_column(p_cur_get_rs_camp, 5, P_rs_camp_Rec.END_DATE);
687: dbms_sql.define_column(p_cur_get_rs_camp, 6, P_rs_camp_Rec.STATUS, 1);
688: dbms_sql.define_column(p_cur_get_rs_camp, 7, P_rs_camp_Rec.ENABLED_FLAG, 1);

Line 685: dbms_sql.define_column(p_cur_get_rs_camp, 4, P_rs_camp_Rec.START_DATE);

681: -- define all columns for AST_TEST view
682: dbms_sql.define_column(p_cur_get_rs_camp, 1, P_rs_camp_Rec.RS_CAMPAIGN_ID);
683: dbms_sql.define_column(p_cur_get_rs_camp, 2, P_rs_camp_Rec.RESOURCE_ID);
684: dbms_sql.define_column(p_cur_get_rs_camp, 3, P_rs_camp_Rec.CAMPAIGN_ID);
685: dbms_sql.define_column(p_cur_get_rs_camp, 4, P_rs_camp_Rec.START_DATE);
686: dbms_sql.define_column(p_cur_get_rs_camp, 5, P_rs_camp_Rec.END_DATE);
687: dbms_sql.define_column(p_cur_get_rs_camp, 6, P_rs_camp_Rec.STATUS, 1);
688: dbms_sql.define_column(p_cur_get_rs_camp, 7, P_rs_camp_Rec.ENABLED_FLAG, 1);
689:

Line 686: dbms_sql.define_column(p_cur_get_rs_camp, 5, P_rs_camp_Rec.END_DATE);

682: dbms_sql.define_column(p_cur_get_rs_camp, 1, P_rs_camp_Rec.RS_CAMPAIGN_ID);
683: dbms_sql.define_column(p_cur_get_rs_camp, 2, P_rs_camp_Rec.RESOURCE_ID);
684: dbms_sql.define_column(p_cur_get_rs_camp, 3, P_rs_camp_Rec.CAMPAIGN_ID);
685: dbms_sql.define_column(p_cur_get_rs_camp, 4, P_rs_camp_Rec.START_DATE);
686: dbms_sql.define_column(p_cur_get_rs_camp, 5, P_rs_camp_Rec.END_DATE);
687: dbms_sql.define_column(p_cur_get_rs_camp, 6, P_rs_camp_Rec.STATUS, 1);
688: dbms_sql.define_column(p_cur_get_rs_camp, 7, P_rs_camp_Rec.ENABLED_FLAG, 1);
689:
690: -- Debug Message

Line 687: dbms_sql.define_column(p_cur_get_rs_camp, 6, P_rs_camp_Rec.STATUS, 1);

683: dbms_sql.define_column(p_cur_get_rs_camp, 2, P_rs_camp_Rec.RESOURCE_ID);
684: dbms_sql.define_column(p_cur_get_rs_camp, 3, P_rs_camp_Rec.CAMPAIGN_ID);
685: dbms_sql.define_column(p_cur_get_rs_camp, 4, P_rs_camp_Rec.START_DATE);
686: dbms_sql.define_column(p_cur_get_rs_camp, 5, P_rs_camp_Rec.END_DATE);
687: dbms_sql.define_column(p_cur_get_rs_camp, 6, P_rs_camp_Rec.STATUS, 1);
688: dbms_sql.define_column(p_cur_get_rs_camp, 7, P_rs_camp_Rec.ENABLED_FLAG, 1);
689:
690: -- Debug Message
691: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: Define Columns Ends');

Line 688: dbms_sql.define_column(p_cur_get_rs_camp, 7, P_rs_camp_Rec.ENABLED_FLAG, 1);

684: dbms_sql.define_column(p_cur_get_rs_camp, 3, P_rs_camp_Rec.CAMPAIGN_ID);
685: dbms_sql.define_column(p_cur_get_rs_camp, 4, P_rs_camp_Rec.START_DATE);
686: dbms_sql.define_column(p_cur_get_rs_camp, 5, P_rs_camp_Rec.END_DATE);
687: dbms_sql.define_column(p_cur_get_rs_camp, 6, P_rs_camp_Rec.STATUS, 1);
688: dbms_sql.define_column(p_cur_get_rs_camp, 7, P_rs_camp_Rec.ENABLED_FLAG, 1);
689:
690: -- Debug Message
691: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: Define Columns Ends');
692:

Line 707: dbms_sql.column_value(p_cur_get_rs_camp, 1, X_rs_camp_Rec.RS_CAMPAIGN_ID);

703: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: Get Column Values Begins');
704:
705:
706: -- get all column values for AST_TEST table
707: dbms_sql.column_value(p_cur_get_rs_camp, 1, X_rs_camp_Rec.RS_CAMPAIGN_ID);
708: dbms_sql.column_value(p_cur_get_rs_camp, 2, X_rs_camp_Rec.RESOURCE_ID);
709: dbms_sql.column_value(p_cur_get_rs_camp, 3, X_rs_camp_Rec.CAMPAIGN_ID);
710: dbms_sql.column_value(p_cur_get_rs_camp, 4, X_rs_camp_Rec.START_DATE);
711: dbms_sql.column_value(p_cur_get_rs_camp, 5, X_rs_camp_Rec.END_DATE);

Line 708: dbms_sql.column_value(p_cur_get_rs_camp, 2, X_rs_camp_Rec.RESOURCE_ID);

704:
705:
706: -- get all column values for AST_TEST table
707: dbms_sql.column_value(p_cur_get_rs_camp, 1, X_rs_camp_Rec.RS_CAMPAIGN_ID);
708: dbms_sql.column_value(p_cur_get_rs_camp, 2, X_rs_camp_Rec.RESOURCE_ID);
709: dbms_sql.column_value(p_cur_get_rs_camp, 3, X_rs_camp_Rec.CAMPAIGN_ID);
710: dbms_sql.column_value(p_cur_get_rs_camp, 4, X_rs_camp_Rec.START_DATE);
711: dbms_sql.column_value(p_cur_get_rs_camp, 5, X_rs_camp_Rec.END_DATE);
712: dbms_sql.column_value(p_cur_get_rs_camp, 6, X_rs_camp_Rec.STATUS);

Line 709: dbms_sql.column_value(p_cur_get_rs_camp, 3, X_rs_camp_Rec.CAMPAIGN_ID);

705:
706: -- get all column values for AST_TEST table
707: dbms_sql.column_value(p_cur_get_rs_camp, 1, X_rs_camp_Rec.RS_CAMPAIGN_ID);
708: dbms_sql.column_value(p_cur_get_rs_camp, 2, X_rs_camp_Rec.RESOURCE_ID);
709: dbms_sql.column_value(p_cur_get_rs_camp, 3, X_rs_camp_Rec.CAMPAIGN_ID);
710: dbms_sql.column_value(p_cur_get_rs_camp, 4, X_rs_camp_Rec.START_DATE);
711: dbms_sql.column_value(p_cur_get_rs_camp, 5, X_rs_camp_Rec.END_DATE);
712: dbms_sql.column_value(p_cur_get_rs_camp, 6, X_rs_camp_Rec.STATUS);
713: dbms_sql.column_value(p_cur_get_rs_camp, 7, X_rs_camp_Rec.ENABLED_FLAG);

Line 710: dbms_sql.column_value(p_cur_get_rs_camp, 4, X_rs_camp_Rec.START_DATE);

706: -- get all column values for AST_TEST table
707: dbms_sql.column_value(p_cur_get_rs_camp, 1, X_rs_camp_Rec.RS_CAMPAIGN_ID);
708: dbms_sql.column_value(p_cur_get_rs_camp, 2, X_rs_camp_Rec.RESOURCE_ID);
709: dbms_sql.column_value(p_cur_get_rs_camp, 3, X_rs_camp_Rec.CAMPAIGN_ID);
710: dbms_sql.column_value(p_cur_get_rs_camp, 4, X_rs_camp_Rec.START_DATE);
711: dbms_sql.column_value(p_cur_get_rs_camp, 5, X_rs_camp_Rec.END_DATE);
712: dbms_sql.column_value(p_cur_get_rs_camp, 6, X_rs_camp_Rec.STATUS);
713: dbms_sql.column_value(p_cur_get_rs_camp, 7, X_rs_camp_Rec.ENABLED_FLAG);
714:

Line 711: dbms_sql.column_value(p_cur_get_rs_camp, 5, X_rs_camp_Rec.END_DATE);

707: dbms_sql.column_value(p_cur_get_rs_camp, 1, X_rs_camp_Rec.RS_CAMPAIGN_ID);
708: dbms_sql.column_value(p_cur_get_rs_camp, 2, X_rs_camp_Rec.RESOURCE_ID);
709: dbms_sql.column_value(p_cur_get_rs_camp, 3, X_rs_camp_Rec.CAMPAIGN_ID);
710: dbms_sql.column_value(p_cur_get_rs_camp, 4, X_rs_camp_Rec.START_DATE);
711: dbms_sql.column_value(p_cur_get_rs_camp, 5, X_rs_camp_Rec.END_DATE);
712: dbms_sql.column_value(p_cur_get_rs_camp, 6, X_rs_camp_Rec.STATUS);
713: dbms_sql.column_value(p_cur_get_rs_camp, 7, X_rs_camp_Rec.ENABLED_FLAG);
714:
715: -- Debug Message

Line 712: dbms_sql.column_value(p_cur_get_rs_camp, 6, X_rs_camp_Rec.STATUS);

708: dbms_sql.column_value(p_cur_get_rs_camp, 2, X_rs_camp_Rec.RESOURCE_ID);
709: dbms_sql.column_value(p_cur_get_rs_camp, 3, X_rs_camp_Rec.CAMPAIGN_ID);
710: dbms_sql.column_value(p_cur_get_rs_camp, 4, X_rs_camp_Rec.START_DATE);
711: dbms_sql.column_value(p_cur_get_rs_camp, 5, X_rs_camp_Rec.END_DATE);
712: dbms_sql.column_value(p_cur_get_rs_camp, 6, X_rs_camp_Rec.STATUS);
713: dbms_sql.column_value(p_cur_get_rs_camp, 7, X_rs_camp_Rec.ENABLED_FLAG);
714:
715: -- Debug Message
716: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: Get Column Values Ends');

Line 713: dbms_sql.column_value(p_cur_get_rs_camp, 7, X_rs_camp_Rec.ENABLED_FLAG);

709: dbms_sql.column_value(p_cur_get_rs_camp, 3, X_rs_camp_Rec.CAMPAIGN_ID);
710: dbms_sql.column_value(p_cur_get_rs_camp, 4, X_rs_camp_Rec.START_DATE);
711: dbms_sql.column_value(p_cur_get_rs_camp, 5, X_rs_camp_Rec.END_DATE);
712: dbms_sql.column_value(p_cur_get_rs_camp, 6, X_rs_camp_Rec.STATUS);
713: dbms_sql.column_value(p_cur_get_rs_camp, 7, X_rs_camp_Rec.ENABLED_FLAG);
714:
715: -- Debug Message
716: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: Get Column Values Ends');
717:

Line 784: DBMS_SQL.BIND_VARIABLE(p_cur_get_rs_camp, ':p_RS_CAMPAIGN_ID', P_rs_camp_Rec.RS_CAMPAIGN_ID);

780: -- developers can copy and paste them.
781: IF( (P_rs_camp_Rec.RS_CAMPAIGN_ID IS NOT NULL) AND (P_rs_camp_Rec.RS_CAMPAIGN_ID <> FND_API.G_MISS_NUM) )
782:
783: THEN
784: DBMS_SQL.BIND_VARIABLE(p_cur_get_rs_camp, ':p_RS_CAMPAIGN_ID', P_rs_camp_Rec.RS_CAMPAIGN_ID);
785:
786: END IF;
787:
788: -- Debug Message

Line 1097: l_cur_get_rs_camp := dbms_sql.open_cursor;

1093: -- Debug Message
1094: JTF_PLSQL_API.Debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: Open and Parse Cursor');
1095:
1096:
1097: l_cur_get_rs_camp := dbms_sql.open_cursor;
1098:
1099: -- Hint: concatenate all where clause (include flex field/line level if any applies)
1100: -- dbms_sql.parse(l_cur_get_rs_camp, l_select_cl || l_head_where || l_flex_where || l_lines_where
1101:

Line 1100: -- dbms_sql.parse(l_cur_get_rs_camp, l_select_cl || l_head_where || l_flex_where || l_lines_where

1096:
1097: l_cur_get_rs_camp := dbms_sql.open_cursor;
1098:
1099: -- Hint: concatenate all where clause (include flex field/line level if any applies)
1100: -- dbms_sql.parse(l_cur_get_rs_camp, l_select_cl || l_head_where || l_flex_where || l_lines_where
1101:
1102: -- || l_steam_where || l_order_by_cl, dbms_sql.native);
1103:
1104: -- Hint: Developer should implement Bind Variables procedure according to bind variables in the parameter list

Line 1102: -- || l_steam_where || l_order_by_cl, dbms_sql.native);

1098:
1099: -- Hint: concatenate all where clause (include flex field/line level if any applies)
1100: -- dbms_sql.parse(l_cur_get_rs_camp, l_select_cl || l_head_where || l_flex_where || l_lines_where
1101:
1102: -- || l_steam_where || l_order_by_cl, dbms_sql.native);
1103:
1104: -- Hint: Developer should implement Bind Variables procedure according to bind variables in the parameter list
1105:
1106: -- Bind(l_crit_rs_camp_rec, l_crit_exp_purchase_rec, p_start_date, p_end_date,

Line 1126: l_ignore := dbms_sql.execute(l_cur_get_rs_camp);

1122: -- Debug Message
1123: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: Execute Dsql');
1124:
1125:
1126: l_ignore := dbms_sql.execute(l_cur_get_rs_camp);
1127:
1128: -- Debug Message
1129: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: Fetch Results');
1130:

Line 1141: IF((dbms_sql.fetch_rows(l_cur_get_rs_camp)>0) AND ((p_return_tot_count = FND_API.G_TRUE)

1137: LOOP
1138: -- 1. There are more rows in the cursor.
1139: -- 2. User does not care about total records, and we need to return more.
1140: -- 3. Or user cares about total number of records.
1141: IF((dbms_sql.fetch_rows(l_cur_get_rs_camp)>0) AND ((p_return_tot_count = FND_API.G_TRUE)
1142: OR (l_returned_rec_count 1143: THEN
1144: -- Debug Message
1145: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'AST', 'Private API: found');

Line 1150: -- dbms_sql.column_value(l_cur_get_opp, 1, l_opp_rec.lead_id);

1146:
1147:
1148:
1149: -- Hint: Developer need to implement this part
1150: -- dbms_sql.column_value(l_cur_get_opp, 1, l_opp_rec.lead_id);
1151: -- dbms_sql.column_value(l_cur_get_opp, 7, l_opp_rec.customer_id);
1152: -- dbms_sql.column_value(l_cur_get_opp, 8, l_opp_rec.address_id);
1153:
1154: -- Hint: Check access for this record (e.x. AS_ACCESS_PVT.Has_OpportunityAccess)

Line 1151: -- dbms_sql.column_value(l_cur_get_opp, 7, l_opp_rec.customer_id);

1147:
1148:
1149: -- Hint: Developer need to implement this part
1150: -- dbms_sql.column_value(l_cur_get_opp, 1, l_opp_rec.lead_id);
1151: -- dbms_sql.column_value(l_cur_get_opp, 7, l_opp_rec.customer_id);
1152: -- dbms_sql.column_value(l_cur_get_opp, 8, l_opp_rec.address_id);
1153:
1154: -- Hint: Check access for this record (e.x. AS_ACCESS_PVT.Has_OpportunityAccess)
1155: -- Return this particular record if

Line 1152: -- dbms_sql.column_value(l_cur_get_opp, 8, l_opp_rec.address_id);

1148:
1149: -- Hint: Developer need to implement this part
1150: -- dbms_sql.column_value(l_cur_get_opp, 1, l_opp_rec.lead_id);
1151: -- dbms_sql.column_value(l_cur_get_opp, 7, l_opp_rec.customer_id);
1152: -- dbms_sql.column_value(l_cur_get_opp, 8, l_opp_rec.address_id);
1153:
1154: -- Hint: Check access for this record (e.x. AS_ACCESS_PVT.Has_OpportunityAccess)
1155: -- Return this particular record if
1156: -- 1. The caller has access to record.